iTechtalk

atom

Changing the Chart Type and Formatting the Chart in Excel 2007:-

You can use the tools on the Design ribbon to change from a default chart type to almost any other chart type. (However, you cannot use scatter, XY, or bubble charts as pivot charts.) To change the chart type, you choose Design, Change Chart Type and select a chart type from the gallery.

You can use the tools on the Layout ribbon to change elements such as data labels, titles, or the 3-D rotation. To create this chart, you use the familiar tools on the Design and Layout ribbon tabs:

1. On the Design ribbon, choose Change Chart Type and select a 3-D pie chart.

2. On the Layout ribbon, choose Chart Title, None.

3. Choose Layout, Legend, None.

4. Choose Data Labels, More Data Label Options, Category Name, Percentage, Outside End. Uncheck the Value box.