excel training courses - How do I get rid of the link between pivot tables and charts?

The UK's most regular instructor-led training courses.
Training information: excel training courses · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

How do I get rid of the link between pivot tables and charts?

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 4 Wed, 12:57) Reply

Cheers

Hazel

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

RE: How do I get rid of the link between pivot tables and charts

by - trainer Tracy platinum contributer [586 posts] (2007 Jul 5 Thu, 10:47) Edited on 2007 Jul 5 Thu, 10:48 Reply

Hi Hazel,

You can simply delete the sheet and thereby deleting the pivot Chart! Pivot tables are only allowed to have one pivot chart.

Let me know if there is anything else

Tracy

· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel Training: Not Just for Newbies Anymore
· Excel Macros for the Non-Programmer
· Identifying Suitable Candidates For VBA For Excel Training
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips