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

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

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!!!