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 |
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 |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com