Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more.  To view the charts available click the Insert Tab on the Ribbon.

Create a Chart

To create a chart:

  • Select the cells that contain the data you want to use in the chart
  • Click the Insert tab on the Ribbon
  • Click the type of Chart you want to create

Modify a Chart

Once you have created a chart you can do several things to modify the chart.

To move the chart:

  • Click the Chart and Drag it another location on the same worksheet, or
  • Click the Move Chart button on the Design tab
  • Choose the desired location (either a new sheet or a current sheet in the workbook)

To change the data included in the chart:

  • Click the Chart
  • Click the Select Data button on the Design tab

To reverse which data are displayed in the rows and columns:

  • Click the Chart
  • Click the Switch Row/Column button on the Design tab

To modify label and titles:

  • Click the Chart
  • Click the Chart Title or the Data Labels button
  • Change the Title and click away

Chart Tools

The Chart Tools appear on the Ribbon when you click on the chart.  The tools are located on three tabs:  Design, Layout, and Format.

  • Within the Design tab you can control the chart layouts, styles, data, type, and location.
  • Within the Format tab you can modify shape styles, word styles and size of the chart.
Sort and Filter

Get industry recognized certification – Contact us