Change bars color

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" <Marcelo@discussions.microsoft.com> wrote in message
news:F9EE1CBE-5C7A-4BBF-B64E-0D2641D9803C@microsoft.com...
> 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" <Marcelo@discussions.microsoft.com> wrote in message
> news:F9EE1CBE-5C7A-4BBF-B64E-0D2641D9803C@microsoft.com...
> > 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
> >
>
>
>