training microsoft excel - 2 data series in one pivot chart

Resolved · Low Priority · Version Standard

2 data series in one pivot chart

Zohra has attended:
Excel Advanced course
Excel Intermediate course
Excel VBA course

by - delegate Zohra [10 posts] (2007 Sep 12 Wed, 12:30) Reply

Hello,

I have creted a pivot chart from a pivot table. I would like to modify the table to include a running total, and add this line to the graph without erasing the former lines.

Is this possible?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: 2 data series in one pivot chart

by - trainer Richard platinum contributer [818 posts] (2007 Oct 2 Tue, 11:11) Reply

If you add the running total to the pivot table, you will have that field present in the Chart.

You can format the new data series RUNNING TOTAL in the Pivot chart separately if need be. Just double click on that data line and format it appropriately.