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
filters allow you to filter the items in the list based on values in other fields. For example,
you can choose all customers where the sum of revenue is over $1 million. Or you can use
the Top 10 Filter to limit the pivot chart to the top five customers.
Every Axis and Legend field features a value filter. You will also see either label or date fil-
ters based on the type of data that Excel finds in the original column.
8
Chapter 8 Creating and Using Pivot Charts
278
In order to see the date filters,all the values in the original column must be formatted as dates
when you create the pivot table.One single cell with a text value in a column of one million ...
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