Pivot Chart doesn't work for me

B

billy_bags

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
 
E

Ed Ferrero

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top