- Start with Excel running and displaying the worksheet containing the data
- Are the data that you want to plot in two rows of the table or in two columns?
- if the columns to be plotted are not adjacent to one another, you must click on the top of the first column on the number of that column. Then press the control button and click on the top of the second column on the number of that column
- if the columns to be plotted are adjacent to one another, you must click on the top of the first column on the number of that column. Then press shift and click on the top of the adjacent column on that column's number
- if the rows to be plotted are not adjacent to one another, you must click on the left of the first row on the number of that column. Then press the control button and click on the left of the second row on the number of that row.
- if the rows to be plotted are adjacent to one another, you must click on the left of the first row on the number of that row. Then press shift and click on the left of the adjacent row on that column's number
- Pull down the
**Insert**menu on the menu bar and select**Chart**. - The Chart Wizzard will open and guide you to make the choices for your the layout of your chart.
- Make sure that you label the axes properly, including the units.
- For most graphs it may be most useful to put them onto a new sheet, in particular when they are very busy.
- You can edit the chart by clicking individual components such as axes, labels, symbols etc. Interactive self-explanatory menus will pop up.
- Another way to edit the chart is by highlighting it by clicking anywhere
on the chart and pull down the
**Chart**menu on the menu bar.

If the data are in columns, select two columns for plotting...

If the data are in rows, select two rows for plotting...