• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 4. Inserting Charts > Choosing a Chart Type

Choosing a Chart Type

The default chart type is 3-D clustered column. You can choose a different chart type before or after you enter data in the datasheet. In addition to choosing a chart type, you can choose a sub-type. Sub-types are variations of the selected chart type. For example, a column chart has sub-types of clustered bars, stacked bars, 100% stacked bars, and so forth.

To choose a chart type:

If necessary, double-click the embedded chart to go into Microsoft Graph.

Choose Chart > Chart Type.

The Chart Type dialog box appears (Figure 4.15).

Click one of the chart types.

Click the desired sub-type.

Click OK.

Figure 4.15. Select a chart type from the Chart Type dialog box.


Another way to change the chart type is with the Chart Type button on the Graph toolbar (Figure 4.16). By clicking the arrow next to the button, you will see a palette of 18 chart types.


To change the type of just one of the series, select the series before you give the Chart Type command. For example, if you want one of the series in a column chart to be a line, select the series, choose the Chart Type command, and choose one of the Line chart types.


You can also change the shape of indi- vidual series in a 3-D bar or column chart. Select the series, choose the Format > Selected Data Series command, and select the Shape tab. You can then select a shape, such as a cylinder, pyramid, or cone.

Figure 4.16. Use the Graph toolbar to select a chart type.

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