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?

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marcelo" wrote in message
...
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?

--
regards from Brazil
Thanks in advance for your feedback.
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:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Marcelo" wrote in message
...
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?

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo