Pivot Charts in Excel v.X?

T

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?
 
J

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?
Click to expand...

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

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.
 
Top