Skip to Content
Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
book

Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007

by Bill Jelen
April 2007
Beginner to intermediate content levelBeginner to intermediate
480 pages
17h 6m
English
Que
Content preview from Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
4. Click OK. Excel adds a new virtual field called Years to your field list and adds this
field to the Row Labels field. The original field called Date is recast to include
months.
5. Click the chart to put away the PivotTable Tools ribbon tabs and bring back the
PivotChart Tools ribbon tabs.
After grouping, you can see details by month and year, as shown in Figure 8.8.
8
Chapter 8 Creating and Using Pivot Charts
274
Figure 8.8
Excel presents both
years and months
along the horizontal
axis.
Although the grouping feature initially adds both the year and month information to the
same area of the pivot table, you can easily split them apart in order to show year ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Mark Dodge, Craig Stinson
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Become a Game-Changing Leader

How to Become a Game-Changing Leader

Douglas A. Ready, Alan Mulally

Publisher Resources

ISBN: 0789736101Purchase book