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.