Microsoft Office Tutorials and References
In Depth Information
Trying another view of the data
Use this dialog box to change the chart type.
The main chart categories are listed on the left, and the subtypes are shown as a
horizontal row of icons. Select an icon and the display shows how the chart will look in both data
orientations. When you ﬁ nd a suitable chart type, click OK and Excel changes the chart.
Notice that this dialog box has a tab at the top that lets you access Excel’s recommended
chart types for the data.
If you don’t like the result after clicking OK, select Undo from the Quick Access Toolbar.
You can also change the chart type by selecting the chart and using the controls in the Insert ➪ Charts group.
Figure 18.10 shows a few different chart type options using the customer satisfaction data.