Microsoft Office Tutorials and References
In Depth Information
Trying another view of the data
Trying another view of the data
The chart, at this point, shows six clusters (months) of three data points in each (age
groups). Would the data be easier to understand if you plotted the information in the
opposite way?
Try it. Select the chart and then choose Chart Tools Design Data Switch Row/Column.
Figure 18.8 shows the result of this change.
FIGURE 18.8
The chart, after changing the row and column orientation
18
The orientation of the data has a drastic effect on the look of your chart. Excel has its own rules that it uses to
determine the initial data orientation when you create a chart. If Excel’s orientation doesn’t match your expectation, it’s
easy enough to change.
The chart, with this new orientation, reveals information that wasn’t so apparent in the
original version. The <30 and 30–49 age groups both show a decline in satisfaction for
March and April. The 50+ age group didn’t have this problem, however.
Trying other chart types
Although a clustered column chart seems to work well for this data, there’s no harm in
checking out some other chart types. Choose Design
Change Chart Type to
experiment with other chart types. This command displays the Change Chart Type dialog box,
shown in Figure 18.9. The fi gure shows how the data would look as a line chart.
Type
Search JabSto ::




Custom Search