Creating charts

In Design Mode, select the data.

Click Chart Wizard in the Objects toolbar.

Select a chart type and sub-type.

See Chart types

Ensure that the range of cells that contains the chart data is correctly specified. The range of cells is specified in the format

Report!$C$8:$D$9

.

Specify whether the chart displays the columns of data in the source data, or the rows.

See Data in columns and data in rows

Note: By default, charts in Design Mode display three columns and three rows of sample data. If your chart will have a legend and you want to change the format of the items in the legend, specify the same number of data rows of sample data as there will be legend items.

See Formatting chart legends

Note: Also, if you want to specify the number of categories displayed on the Category axis of a chart, specify the same number of categories of sample data as there are actual categories.

See Scaling tab.

Optionally, select "Display message when chart area becomes too small".

This option will warn you if a chart contains too many data series to display correctly. It applies to charts with 1000 data series or more.

Optionally, specify titles for the chart and for the X and Y axes (and secondary axes if they are used).

Or, you can specify titles on the Titles tab of the Chart Options dialog. dialog. There, you can also specify the units displayed on each axis.

SeeChart Options.