Pivot Chart

[jojoteo77]

Hi,

I realised that the pivot chart cannot create XY scatter graph. All it
can offer is bar, pie and line charts.

Is there a way to resolve this? I need a scatter graph based on my
pivot data.

Thanks,
Jojo

 

[Roger Govier]

Hi Jojo

Mark an area that encompasses your Pivot Table>Copy>paste Special values>use
that data as the source for your XY scatter.
That will be a fixed report, that will not alter if your PT alters.

If the data is going to alter, and you want your XY scatter to reflect this,
then create another Tables using the GetPivotData function to extract the
data from your PT, and base your XY scatter on this new table.
For more help on GetPivotData take a look at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html