If you create a pivot chart, it should show all the data that's in the
pivot table. What problem are you having with the chart?

Steve J wrote:
Hi is it possible to have 2 separate sets of series in one table/chart.

i have 4 rows - Weeks 1-4
I have 8 columns - Qty 1-4 and Cost 1-4

I would like to display all the data in one table/chart?

Thanks
S




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html