To begin this section, you should still have the information from section 8 entered in your spreadsheet.
When creating a graph in Excel the columns of data must be in the order
X Y1 Y2 Y3 .... X values in first column, Y values in the second column and there can be multiple columns of Y values.
Highlight A1 - B6 (or wherever your data is located)
Go to Insert
Follow these instructions to go through the four step chart wizard:
A chart will appear!
We want to get rid of the gray area:
Double click anywhere in gray area (not on any line or square)
Under Area Click on None
To put a legend on the graph:
Go to Chart, then chart options and you can insert a legend.
To return to your worksheet:
Click on sheet1 at the bottom left hand corner
This tutorial was written by Dr. Laura Maki, it was last updated for Excel2000 on February 25th by Koni Stone
Back to the Tutorial
This tutorial was written by Dr. Laura Maki, it was last updated for Excel2000 on February 25th by Koni Stone.