Su has attended:
Excel Advanced course
Graphs
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
RE: Graphs
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
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
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!
