Steven has attended:
Excel Advanced course
Pivot Charts in Excel 2007
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)
RE: Pivot Charts in Excel 2007 Filtered data on the chart
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