Greetings,
I've never used Excel before, but must now form a line graph in Excel for a class project. I don't know how to combine 2 line graphs on one chart for comparison. Can anyone help me?
The first data set is motor production numbers for consecutive years from 1947 - 1989, but we are also being required to create a second time line showing a four-year running average for this time period. I realize that the averages would appear at the median of each set in the second line (ex. 2.5 for years 1-4, 6.5 for years 5-8), but I just don't know how to create one graph that shows both time lines.
Thanks for any help!
I've never used Excel before, but must now form a line graph in Excel for a class project. I don't know how to combine 2 line graphs on one chart for comparison. Can anyone help me?
The first data set is motor production numbers for consecutive years from 1947 - 1989, but we are also being required to create a second time line showing a four-year running average for this time period. I realize that the averages would appear at the median of each set in the second line (ex. 2.5 for years 1-4, 6.5 for years 5-8), but I just don't know how to create one graph that shows both time lines.
Thanks for any help!