Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary bar colors by bar
I would like to vary the colors on a bar chart by bar.
The chart plots 7 points agains a standard. The standard has the value of 100. The points change based on information received weekly. This will cause the bars to, sometimes, be above the standard and, sometimes, below the standard. How can I force the bars to change colors with every update so that when the bar goes over the chart it will be green but when it falls below the chart it will be red? Tim |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vary bar colors by bar
Hi,
Have a look at Jon's example of conditional charting. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Tim wrote: I would like to vary the colors on a bar chart by bar. The chart plots 7 points agains a standard. The standard has the value of 100. The points change based on information received weekly. This will cause the bars to, sometimes, be above the standard and, sometimes, below the standard. How can I force the bars to change colors with every update so that when the bar goes over the chart it will be green but when it falls below the chart it will be red? Tim -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing *permanently* Excel's colors and graph fill for charting? | Charts and Charting in Excel | |||
not showing colors sometimes | Excel Discussion (Misc queries) | |||
Vary colors in area chart by x-axis value | Charts and Charting in Excel | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
Colors and printing | Excel Worksheet Functions |