Introduction to Charts in MS Excel

Introduction to Charts in MS Excel

In the next part of this training series I show you how to set up charts in Microsoft Excel.

Download this lesson on excel charts as a pdf: Introduction to Charts

To Create a chart using the Chart wizard

  1. Select the data on your worksheet, that you want to create the chart from.
  2. Click on the Chart Wizard button on the toolbar.



When you release the mouse button Step1 of the Chart Wizard will be displayed.

pic 2


  1. Under the Chart type: option, click on the different chart types to view the types of  chart that you want to create.
  2. Under the Chart sub type option, click on the sub-type you would like for your chart.
  3. To see how your data would look using a certain chart type, press and hold to view sample button.
  4. When you have found the type of chart you would like to create, click on the next button.
  5. Next to the data range option, check that the range you selected on your worksheet is correct, if the range is incorrect click on the selector button, reselect the range on your worksheet, and then click the selector button again.

pic 3


Click the next button.

pic 4


  1. Under the Chart title box, type in the title you would like for your chart, and any axis titles.
  2. Click on the Legend tab, and choose whether you would like a legend displayed, and its position.
  3. Click on the Data Labels tab, and choose whether you would like your data labelled.
  4. When you have finished choosing titles, legends, labels and any other details, click on the Next button.

pic 5


  1. The final part is to decide whether you would like your chart displayed as a new sheet or included on the same sheet as your data.
  2. Click on the Finish button.


Don’t forget you down download the introduction to charts as a PDF: Introduction to Charts

Other Lessons



Rob Boyle

Hi there! I'm Rob, writer of most articles around here. I run this website as a way to give my opinions on and alert others to recent events in the world of technology.

Visit Website