| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color change for Column Chart
Hi Everyone
I'm using a column chart, always 4 columns. Is it possible to have each column change color automatically based on criteria Below 7 = Green Between 7 and 9.9 = Orange 10 and above = Red TIA John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color change for Column Chart
See attached Screen shot sample.
http://cjoint.com/?fev2shbXLa "John" wrote in message ... Hi Everyone I'm using a column chart, always 4 columns. Is it possible to have each column change color automatically based on criteria Below 7 = Green Between 7 and 9.9 = Orange 10 and above = Red TIA John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color change for Column Chart
From Jon Peltier's main page
http://peltiertech.com/ search "conditional" without the quotes. The Simple conditional column chart looks like what you're after. Regards, Peter T "John" wrote in message ... Hi Everyone I'm using a column chart, always 4 columns. Is it possible to have each column change color automatically based on criteria Below 7 = Green Between 7 and 9.9 = Orange 10 and above = Red TIA John |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color change for Column Chart
Hi Peter
I will have a look at it, thank you. Regards John "Peter T" <peter_t@discussions wrote in message ... From Jon Peltier's main page http://peltiertech.com/ search "conditional" without the quotes. The Simple conditional column chart looks like what you're after. Regards, Peter T "John" wrote in message ... Hi Everyone I'm using a column chart, always 4 columns. Is it possible to have each column change color automatically based on criteria Below 7 = Green Between 7 and 9.9 = Orange 10 and above = Red TIA John |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color change for Column Chart
Hi Peter
I got it working, Thanks again John "Peter T" <peter_t@discussions wrote in message ... From Jon Peltier's main page http://peltiertech.com/ search "conditional" without the quotes. The Simple conditional column chart looks like what you're after. Regards, Peter T "John" wrote in message ... Hi Everyone I'm using a column chart, always 4 columns. Is it possible to have each column change color automatically based on criteria Below 7 = Green Between 7 and 9.9 = Orange 10 and above = Red TIA John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color to selected columns in a stacked column chart | Charts and Charting in Excel | |||
| change color of column chart | Excel Programming | |||
| Change column color in chart when column value is over/under goal | Charts and Charting in Excel | |||
| Bar chart: change color of a bar to red if value > x? | Charts and Charting in Excel | |||
| Dynamically change column color in chart | Excel Programming | |||
![John[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
