Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Recoloring Plot Area of Chart
Hi All,
I´m not familiar with VB(A) programming, but I guess, my issue could be solved by a macro. So I a have a chart with values on the VauleAxis from 0 to 7. Is there a way, to recolor the plot area, so that the value range form 0 to 2 is e.g. red, the range from 2 to 6 green, and so on? Any help is appreciated! Thanks in advance, Daniel |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Recoloring Plot Area of Chart
Hi,
No need for code. http://peltiertech.com/Excel/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "daniel_of_vienna" wrote in message ... Hi All, I´m not familiar with VB(A) programming, but I guess, my issue could be solved by a macro. So I a have a chart with values on the VauleAxis from 0 to 7. Is there a way, to recolor the plot area, so that the value range form 0 to 2 is e.g. red, the range from 2 to 6 green, and so on? Any help is appreciated! Thanks in advance, Daniel |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Recoloring Plot Area of Chart
On 24 Jan., 09:53, "Andy Pope" wrote:
Hi, No need for code.http://peltiertech.com/Excel/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"daniel_of_vienna" wrote in message ... Hi All, I´m not familiar with VB(A) programming, but I guess, my issue could be solved by a macro. So I a have a chart with values on the VauleAxis from 0 to 7. Is there a way, to recolor the plot area, so that the value range form 0 to 2 is e.g. red, the range from 2 to 6 green, and so on? Any help is appreciated! Thanks in advance, Daniel exactly, what I'm looking for! Thank you, Andy!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
is it possible two different colours in a chart plot area ? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |