two colours in the plot are of a chart
 

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

two colours in the plot are of a chart
 

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

two colours in the plot are of a chart
 

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

two colours in the plot are of a chart
 

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