Pivot Table Chart differences in 03 and 07

**liverpoolphil** · 09-17-2009, 05:03 AM

Hope someone can help, I have attached a portion of my Pivot Chart in Excel 2003 and have been trying to recreate this in 2007 with some difficulty

I am particularly interested in displaying the field list headings (specifically 'Count of Hit or Miss') in the pivot chart in 2007 but cannot make it work

Hope this makes sense and someone may be able to help

(p.s. I know I can manually add axis titles but just wondering why in 2007 the headings are not included automatically - as they were in 2003)

Thanks in advance

phil

**Andy Pope** · 09-17-2009, 06:50 AM

In xl2007 the filter buttons on the chart are replaced by a filter pane.
With the chart selected use the ribbon,
Pivotchart tools > Analyze > Show/Hide > PivotChart Filter

**liverpoolphil** · 09-17-2009, 07:00 AM

thanks andy

Any way I can get these to physically appear on the chart?

my PT charts are generally printed and taken to management meetings (where the people at the meeting need to be able to relate the data on the chart to a heading / label)

Phil