PIVOT TABLE/CHART

[Karen]

Howdy. I created a pivot table from a spreadsheet of
data. Then - from the pivot table, I created a pivot
CHART. The pivot chart plots different products sold
within counties. I've got the products set up as SERIES
with a drop down menu and County set up as CATEGORY
fields with the drop down menu. Everything is perfect
UNTIL I email this spreadsheet to another use. They
receive the spreadsheet and pivot table and pivot charts,
but NO drop down menus to choose the products or
counties. I've emailed to various different users within
our Company server and an outside ISP. (AOL) Same
results with all of them. THere are no drop down menus
on the pivot chart. Does anyone have an explanation or
know why this is? ANy help would be greatly appreciated!

 

[Debra Dalgleish]

Are you all using Excel 2000 or later version? In earlier versions there
were no pivot charts, so if the workbook is opened in Excel 97, the
pivot charts would appear as normal charts.