Recoloring Plot Area of Chart

[daniel_of_vienna]

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

 

[Andy Pope]

Hi,

No need for code.
http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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

 

[daniel_of_vienna]

Hi,

No need for code.http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html

Cheers
Andy

--


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