Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Graph colors automatically change
I am trying to create a graph, where each month the numbers will be updated.
I want the positive numbers to show up green in the graph, and the negative numbers to show up red on the graph. I know that I can adjust this manually, but this will be linked to 200 or so department reports. I don't want to do it manually. When I click "invert negative" on the graph dialog box, it turns the negative numbers blue. |
#2
|
|||
|
|||
Graph colors automatically change
Hi,
You can use a custom number format. If you do this for the cells the datalabels should do the same. Otherwise just set the data labels number format. [Green]General;[Red]General And this describes how to use Invert if Negative to get the coloured bars you want. http://www.andypope.info/charts/Invertneg.htm Cheers Andy PuckMark wrote: I am trying to create a graph, where each month the numbers will be updated. I want the positive numbers to show up green in the graph, and the negative numbers to show up red on the graph. I know that I can adjust this manually, but this will be linked to 200 or so department reports. I don't want to do it manually. When I click "invert negative" on the graph dialog box, it turns the negative numbers blue. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
Form Colors on a form change on a laptop pc | New Users to Excel | |||
Modify the default graph colors | Charts and Charting in Excel | |||
How do I automatically change color of value if value is > 50 in . | Excel Discussion (Misc queries) | |||
change one sheet, and automatically the others | Excel Worksheet Functions |