Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible two different colours in a chart plot area ? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
Change the default chart colours | Charts and Charting in Excel | |||
Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel |