Pivot Chart doesn't work for me
I want to create my own chart based on a pivot table.
All I seem to be able to get is a Pivot Chart. Is there a way to achieve this please? Bill |
Pivot Chart doesn't work for me
Hi Bill,
Add an empty chart (do not select the pivot table) Then right-click the chart and... XL 2003 - Select 'Source Data...', then Series tab. Add a series, select cells you want. XL 2007 - Select 'Select Data...' Add a series, select cells you want. Ed Ferrero www.edferrero.com I want to create my own chart based on a pivot table. All I seem to be able to get is a Pivot Chart. Is there a way to achieve this please? Bill |
All times are GMT +1. The time now is 07:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com