Page 11 of 14PREVNEXT

Charts I: How to create a chart

Chart Wizard options

Callout 1 Gridlines
Callout 2 Legend
Callout 3 Data table

There are more tabs in the Chart Wizard, and you'll have a chance in the practice session to see the options on each tab. Each tab includes a preview so that you can see what your chart looks like if you change any of your choices. Various chart types offer various sets of options. For a clustered column chart, the tabs are:

  • Axes     Here you can hide or display the information shown along the axes.
  • Gridlines     Here you can hide or display the lines that extend across the chart.
  • Legend     Here you can place the chart legend in different locations on the chart.
  • Data Labels     Here you can label the chart with the row and column title for each value, and with the numerical values themselves. Be careful—you can easily clutter a chart and make it hard to read.
  • Data Table     Here you can display a table containing all the data used to create the chart. You might do this if you place a chart on a separate sheet in the workbook and want to have the data visible with the chart. That's next.
  • Chart Location     Step 4 of the wizard gives you the option to place the chart As new sheet or As object in. If you choose a new sheet, you can choose a title for it. If you choose to place the chart as an object, it appears on the same sheet with the worksheet data used in creating it. If you create a chart the quick way by clicking Finish as soon as you see that button in the wizard, the chart is automatically placed As object in.
Page 11 of 14PREVNEXT