- 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 data are in columns, select two columns for plotting...
- 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 data are in rows, select two rows for plotting...
- 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.