Excel 2007 PivotTables and PivotCharts by Peter G. Aitken

By Peter G. Aitken

Realizing PivotTables and charts -- figuring out information assets for PivotTables -- utilizing PivotTable instruments and formatting -- operating with PivotTable parts -- extra approximately PivotTable elements -- figuring out and utilizing PivotCharts -- utilizing PivotTables with multidimensional information -- Getting tough info from a PivotTable -- PivotTable possible choices -- Programming PivotTables with VBA

Show description

Read or Download Excel 2007 PivotTables and PivotCharts PDF

Best software: office software books

Winning the retention wars: The Air Force, women officers, and the need for transformation

The Air strength and the nationwide security project are the large losers while proficient members decide to separate early. even though particular separation figures aren't on hand, research of the proportion of guys and girls by way of commissioned years of carrier within the Air strength shows that ladies separate sooner than retirement extra often than males.

Walking the Tightrope: Solutions for Achieving Life Balance Without a Net

We are extra stressed out than ever: mobile phones on our hips, laptops, electronic mail, speedy messaging. The killer apps are killing us. know-how used to be imagined to make it more straightforward for us, yet we're extra out of stability and out of contact with the issues in lifestyles which are most vital to us than we have been a decade in the past. Orloff and Levinson can assist readers to discover that experience of stability to allow them to deal with the highwire act of dwelling and dealing with no flaming out.

The Unofficial Guide to Microsoft Office Access 2007 (Unofficial Guide)

The interior scoop. .. for in the event you wish greater than the reliable line! Microsoft entry 2007 could be a significant new replace, yet to take advantage of it with self belief, you will need to grasp its quirks and shortcuts. discover what the guide does not continually let you know during this insider's consultant to utilizing entry 2007 within the genuine global.

Microsoft Excel 2010 In Depth

Excel 2010 intensive is the beyond-the-basics, beneath-the-surface consultant for everybody who desires to streamline their paintings with Excel 2010, and get extra performed in much less time. mythical Excel specialist invoice Jelen presents particular, verified, confirmed ideas to the issues Excel clients run into on a daily basis: demanding situations different books forget about or oversimplify.

Extra info for Excel 2007 PivotTables and PivotCharts

Example text

Type the name for the range in the Name field. You should use something descriptive such as SalesData or SurveyResults. It’s best to avoid spaces, too; use an underscore if needed to separate words. 4. Click OK. qxp 24 3/5/07 10:59 PM Page 24 Part I: PivotTable Fundamentals Figure 2-2: Defining a named range. Then, when you are creating a PivotTable, simply enter the range name in the Table/Range field, as shown in Figure 2-3 for the range Name SalesData. Of course, if you enter a name that does not exist, it will not work.

Of course, if you enter a name that does not exist, it will not work. Excel displays an error message when you click OK. You’ll have to correct the range name you entered or use one of the other techniques to specify the source data range for your PivotTable. qxp 3/5/07 10:59 PM Page 25 Chapter 2: Understanding Data Sources for PivotTables 25 Part I Figure 2-3: Specifying the data range by entering a range name in the Create PivotTable dialog box. What About Filters and Subtotals? If you have applied any autofilters or subtotals to your source data, they are ignored when you create a PivotTable from the data.

These are features that you have seen in other PivotTable reports. What’s new is the drop-down arrow next to the Page1 label. This enables you to select which of the data ranges to include, as shown in Figure 2-22. The entries Item1, Item2, and Item3 refer to the three data ranges on which the PivotTable is based. You can select all the ranges or any single range to specify which data are summarized in the PivotTable report. I suggest that you experiment with the filters in this PivotTable report to get a feel for how they work.

Download PDF sample

Rated 4.53 of 5 – based on 43 votes