Recoloring Plot Area of Chart

  • Thread starter Thread starter daniel_of_vienna
  • Start date Start date
D

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
 
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
 
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
Click to expand...

exactly, what I'm looking for!
Thank you, Andy!!!
 
Back
Top