excel london - Graphs

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

Resolved · Low Priority · Version Standard

Graphs

Su has attended:
Excel Advanced course

by - delegate Su [3 posts] (2007 Mar 21 Wed, 16:05) Reply

Is ther a way to change the colour of a graphs (bar chart) depending on a set critia
E.g.

<50% Red
>50 <100 % Yellow
>100% Green

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

RE: Graphs

by - trainer Amanda platinum contributer [968 posts] (2007 Mar 28 Wed, 15:40) Reply

Hi Su

Thanks for your quesiton.

As far as I'm aware, this sort of thing could not be done without writing some VBA code. You can change the colour of cells in your spreadsheet depending on criteria (under Format - Conditional Formatting) if this is any use to you.

Amanda

RE: Graphs

by - delegate Su [3 posts] (2007 Mar 28 Wed, 16:11) Reply

Hello Thank you for your reply.

I did think it would be using some vba code witch is not a problem I just wondered if there was another away around it. I have tried using Conditional formatting but I want it to look like a bar chart rather than just changing a cell a different colour. I will look into finding/building the code I need, unless you have anything that could help me?
Thank you

Su

RE: Graphs

by - trainer Amanda platinum contributer [968 posts] (2007 Mar 28 Wed, 17:00) Reply

Hi Su

Sorry, nothing that I could definitely recommend although I have found that doing searches through Google Groups and using web sites like www.cpearson.com and http://mrexcel.com are useful for finding out how to do things in Excel.

Good luck!

RE: Graphs

by - delegate Su [3 posts] (2007 Mar 29 Thu, 12:27) Reply

Thats great

thanks then

Su

· Do You Really Need Excel VBA Training?
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How to Create Better Excel Spreadsheets: Part Three
· Microsoft Office and the Small Business: Part 1 Excel
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training