Change bars color

[Marcelo]

Hello,

I have a dinamic chart to show the cash flow position, a scrool bar chagne
the data to the past and to the future (estimate), what I am looking for is,
to have an easy identification of the estimated period I would like to chage
the color of the bar.

I am using an Stacked Column chart with two variables.

any Ideias?

 

[Jon Peltier]

What I usually do when I want to show a column chart with one color within a
certain range and another color elsewhere, is create two series, one each
color, and use formulas to change on series to zero within a certain range,
and the other series is zero outside the range. If one color is series A and
the other is series B, it looks like this:

AAAAAAAAAAAAABBBBBBBAAAAAAAAAAAAA

You can extend this so you have 4 series, A and B visible outside the range
and C and D visible inside, all four are stacked columns.

- Jon

 

[Marcelo]

Jon,

Thanks very much for your answer.

have a nice day
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jon Peltier" escreveu: