Help with Excel's Chart Making
I need to make a chart in Excel for an economics class I'm taking, and I'm very frustrated. The data is organized like this:
------Jan--Feb--Mar--Apr--May ...
1980--5----3----3----4----6 ...
1981--7----6----5----7----8 ...
1982--4----6----5----4----6 ...
The statistics are price levels, sampled monthly.
I want to draw a simple line graph with the years along the x-axis, but with each monthly value plotted. The thing is, I'm supposed to plot the data continuously. So there's only supposed to be one line in the chart.
When I try to use the damn Chart Wizard, it draws a different line for each year, which I don't want. We all know how great the included documentation of Office v.X is, and the on-screen help just points me to the damn Chart Wizard again.
I'd be much obliged for any help or pointers that are offered.
------Jan--Feb--Mar--Apr--May ...
1980--5----3----3----4----6 ...
1981--7----6----5----7----8 ...
1982--4----6----5----4----6 ...
The statistics are price levels, sampled monthly.
I want to draw a simple line graph with the years along the x-axis, but with each monthly value plotted. The thing is, I'm supposed to plot the data continuously. So there's only supposed to be one line in the chart.
When I try to use the damn Chart Wizard, it draws a different line for each year, which I don't want. We all know how great the included documentation of Office v.X is, and the on-screen help just points me to the damn Chart Wizard again.
I'd be much obliged for any help or pointers that are offered.
Comments
like this ?
Click For Bigger Image
To the best of my knowledge, you would have to re-order the data in the sheet.
Andrew
Select your chart. You should have a "Chart" menu.
Select "Source data"
Select the "Series" tab
Delete all but one series
Select your X and Y values. If you select discontinuous ranges of data, you should get something like "$A$2:$A$22+$B$1:$B$21" for data in column B rows 1 to 21 concatenated to the data in column A rows 2 to 22.
Thanks for the detailed support. It certainly made this project easier!!