ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot Chart doesn't work for me (https://www.excelbanter.com/charts-charting-excel/138836-pivot-chart-doesnt-work-me.html)

billy_bags

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

Ed Ferrero

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