• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Inserting Charts

Select the cells you want to include in your chart, and click the Chart Wizard button on the Standard toolbar.

The first page of the Chart Wizard opens. Select a type from the Chart Type list and the Chart Sub-type list; then click Next.

Depending on how you want your information to display in the chart, select either Rows or Columns in the Series in area; then click Next.


Interpreting numeric data by looking at numbers in a table can be difficult. Using data to create charts can help people visualize the data's significance. For example, you might not have noticed in a spreadsheet that the same month of every year has low sales figures, but it becomes obvious when you make a chart from the data in that spreadsheet. The chart's visual nature also helps others review your data without the need to review every single number.


Viewing a Sample

The Chart Wizard enables you to select how your data looks with a chart type and subtype. To do so, move your mouse pointer over the Press and Hold to View Sample button and then press and hold down the left mouse button.

Type a Chart title, a value for the Category (X) axis, and any other values you want; then click Next.

Click the As New Sheet option button to enter the chart as a new sheet, or click the As Object in option button to enter the chart in the sheet you select. Click Finish.

Excel creates the chart, displaying it along with a Chart toolbar.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint