Bar Graph In Excel With A Line. You can do it. Right click the new series Data points or the legend and select Chart type.
Right-click anywhere on the existing chart and click Select Data Figure 3. If youre having trouble creating the line graph in excel this is an important skill to master. In column B All Targets.
Choose the XY scatter type.
Select the source data including the Average column A1C7. Dec 23 2015 Right click your chart of interest select paste and then paste special. In column B All Targets. Select to add cells as New Series.
