Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Chart
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Chart
Hi Jojo
Mark an area that encompasses your Pivot TableCopypaste Special valuesuse 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 -- Regards Roger Govier wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) |