Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot charts excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Charts in Excel 2007

Pivot Charts in Excel 2007

ResolvedVersion 2007

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

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.