Create a chart or plot

In addition to conducting analyses, Excel has a facility to create various charts and plots including pivot tables/charts.

For example to create a scatter plot between CALVCON and FIRSTBRD:

  • Select cells from C1 to D7;
  • Click the function button on the toolbar (or go to Insert–>Chart…) to start the chart wizard;
  • Select XY (Scatter) in Step 1 of chart wizard and click Next to go to the next step. Follow the prompts and click Finish in the end to create a scatter plot.

Note that you can use various formatting features to spruce up your charts or plots.

Further information about creating charts

Further information about creating charts can be obtained from the following tutorials available on the Microsoft website: