Microsoft Office Tutorials and References
In Depth Information
Charting Your Data
Figure 2.26.
Figure 2.26. When you have only one column of text, the Quick Analysis of-
When you have only one column of text, the Quick Analysis of-
fers top 10%.
fers top 10%.
Charting Your Data
Charting Your Data
When you click the Quick Analysis and choose the Charting category, Excel
offers five chart thumbnails. Hover over each thumbnail to preview the
chart.
With the current data set, it is tough to predict which column is the most im-
portant. Will you want to chart Q1? Q2? The charts offered for this data
set do not make a lot of sense. For example, in Figure 2.27 , Excel is offering to
roll the data up by sector, but then randomly chooses to show the revenue
in Q2 (note the title, Sum of Q2 by Sector).
Search JabSto ::




Custom Search