Problem viewing Excel 2003 Pivot Chart fields in Excel 2007

R

ronny B

When I’m running Excel 2007 and I’m viewing a chart in a file created in
Excel 2003 using the ‘Pivot Chart and Pivot Chart Report’ functionality, I’m
unable to see the Pivot Chart (drop down) fields anywhere on the Pivot Chart.
This happens even when the file created in Excel 2003 is ‘converted’ to 2007
when it is opened.
 
S

ShaneDevenshire

Hi,

When the pivot chart is selected try choose PivotChart Tools, Analyze, and
turn on the Pivot Chart Filter.
 
P

pramodkumar

Joined
Jan 5, 2009
Messages
1
Reaction score
0
Hi Shane,

I am having the same problem as mentioned below ...when i waent to PivotChart Tools, Analyze, and click on the Pivot Chart Filter ..i got the pane that shows the values that i am trying to see in the form of drop-down box.....But still i am not able to see those drop-down boxes on Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to stop pivot table crashing in Excel 2007 0
Problem Printing Excel Charts 2
Pivot Chart update 1
Pivot chart 1
Scatterplot with background area plot 4
Odd Excel 2007 behavior: copied chart linked to source sheet 4
Chart sheet in Excel 2007 2
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0

Top