Pivot Charts in Excel v.X?

[tim_staton]

Hello all - I am here trying to use my Mac with Office X at business
school. So far so good... The one thing that I cannot do is create a
PivotChart (graphical representation of a PivotTable). Does anybody
know if this is an available add-in, or does Excel X not support it?
If it does not does anybody know if Excel 2004 does?

 

[JE McGimpsey]

Hello all - I am here trying to use my Mac with Office X at business
school. So far so good... The one thing that I cannot do is create a
PivotChart (graphical representation of a PivotTable). Does anybody
know if this is an available add-in, or does Excel X not support it?
If it does not does anybody know if Excel 2004 does?

Neither XLv.X nor XL04 support Pivot Charts, unfortunately.

 

[Geoff Lilley]

The best workaround I've found for that is to ensure that in the
settings for the PivotTable row field, is to show items with no data.
That way, if I filter for different groupings using the page field, the
chart's range is consistent. But the lack of PivotChart is a bit of an
annoyance. Good news is that you can create a chart off of a
PivotTable fairly easily.