Pivot Charts in Excel 2007

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Pivot Charts in Excel 2007

Steven has attended:
Excel Advanced course

by - delegate Steven [1 post] (2008 Apr 28 Mon, 16:50) Reply

When creating a Pivot Chart & adding a field to the report filter field - how do you identify which data element is shown on the chart (i.e. I filtered for Quarter but wasn't able to see what Quarter the data related to on the chart)

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Pivot Charts in Excel 2007 Filtered data on the chart

by - trainer Rajeev gold contributer [275 posts] (2008 May 9 Fri, 14:09) Reply

Dear Steven

Thank you for attending Excel Advanced Course. I hope you enjoyed the course and it was beneficial for you.

The answer to this is not straight forward but it does the rick.

Step 1: Create a Text box on the corner of the Pivot Chart
Step 2: Ensuring the Text box is Selected click on the formula bar and type =
Step 3: Click on eth sheet where the pivot Table is and click on the cell that contains the report Filter cell (i.e. The one that you will keep on changing).
Step 4: Press Enter. You’ll notice that on the formula bar the name of the sheet and the name of the cell with Dollar signs appear.

And it will display the same data that you have selected in the filter list!!

I hope that this answers your question.

I kindly request that you mark this post as resolved if you believe that it has answered your question.

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor

Training by application

Main information pages

Pivot Charts in Excel 2007

Related articles

Excel tip:

No Zeros