Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Graphs
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel london - Graphs
Resolved · Low Priority · Version Standard
Reply
Graphs
Is ther a way to change the colour of a graphs (bar chart) depending on a set critiaE.g.
<50% Red
>50 <100 % Yellow
>100% Green
For upcoming training course dates see: Pricing & availability
RE: Graphs
Hi SuThanks 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 SuSorry, 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!
|
 |
|
» Forum post: V look up |
Hi, 
