two colours in the plot are of a chart

[Manos]

Dear all

There is adiagram with values of a stock
And there are values before 2003 and after 2003

There is possibility in the plot area the colour to be double?
For example in the area of values befor 2003 to be yellow and after 2003 to
be green?

Thanks in advance
Manos

[Jon Peltier]

You could fake it with another series, either a column or a stacked area, on
the same chart:

http://peltiertech.com/Excel/Charts/...ackground.html
http://pubs.logicalexpressions.com/P...cle.asp?ID=508

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Manos" <Manos@discussions.microsoft.com> wrote in message
news:B218F472-0E10-4555-9E3B-3D2BCE3A69CA@microsoft.com...
> Dear all
>
> There is adiagram with values of a stock
> And there are values before 2003 and after 2003
>
> There is possibility in the plot area the colour to be double?
> For example in the area of values befor 2003 to be yellow and after 2003
> to
> be green?
>
> Thanks in advance
> Manos

[Manos]

It seems to complecated but i'll try
thanks a lot
Manos

Ο χρήστης "Jon Peltier" �*γγραψε:

> You could fake it with another series, either a column or a stacked area, on
> the same chart:
>
> http://peltiertech.com/Excel/Charts/...ackground.html
> http://pubs.logicalexpressions.com/P...cle.asp?ID=508
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "Manos" <Manos@discussions.microsoft.com> wrote in message
> news:B218F472-0E10-4555-9E3B-3D2BCE3A69CA@microsoft.com...
> > Dear all
> >
> > There is adiagram with values of a stock
> > And there are values before 2003 and after 2003
> >
> > There is possibility in the plot area the colour to be double?
> > For example in the area of values befor 2003 to be yellow and after 2003
> > to
> > be green?
> >
> > Thanks in advance
> > Manos
>
>
>

[Andy Pope]

Hi,

A variation on this should allow you to colour the plot area.
http://peltiertech.com/Excel/Charts/...ackground.html

Cheers
Andy

Manos wrote:
> Dear all
>
> There is adiagram with values of a stock
> And there are values before 2003 and after 2003
>
> There is possibility in the plot area the colour to be double?
> For example in the area of values befor 2003 to be yellow and after 2003 to
> be green?
>
> Thanks in advance
> Manos

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info