Create a chart in Excel 2000

1. Select the data you want to plot [in columns, preferably]. Include their titles [ie: heat, flow rate] if you want them to show up in the legend. 
2. Make sure your columns from Left to Right are your X and Y coordinates, respectively. 
3. INSERT>chart or click on Chart Wizard. 
4. Choose a chart type. Usually X-Y Scatter. Then choose a specific type of ie: X-Y Scatter. 
5. Select radio button for data in rows or columns, whichever corresponds to yours [usually columns]. 
6. TITLES tab: give your chart a title, X-axis label, Y-axis label. 
7. GRIDLINES tab: varies the gridlines on your chart. 
8. LEGEND tab: lets you not show the legend, or change its position on the graph. 
9. DATA LABELS tab: lets you label the data points [with %values, etc.]. 
10. Select where you want this graph to go: on it's own sheet or embedded in the spreadsheet

<<<Back Home Next>>>