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.