Pivot table charts

Resolved · Low Priority · Version 2003

Pivot table charts

Rachel has attended:
Excel Advanced course

by - delegate Rachel [2 posts] (2008 Jun 30 Mon, 16:39) Reply

Can you use corporate colours in the pivot table charts?

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: pivot table charts

by - trainer Martin bronze contributer [27 posts] (2008 Jul 17 Thu, 12:07) Reply

Morning Rachel,

You can change the colours but you have to watch out how you change it.

Once you have your chart make the relevent changes and then go to Chart Menu, Chart Options, in the bottom right click on "Set as default chart". Everytime you then do a new chart it will keep your colours, but also any changes made to the pivot chart are changed. If you do not set the default then if you change anything on the pivot chart such as choosing different options then you will lose everything you have done. This would only apply if you have clicked bar etc and changed the colour.

If this is for everybody in the company then you would need to speak with the IT department as they would need to change the global template.

Hope this helps
Regards
Martin