Getting different colours in excel charts

[Sukesh]

Hi All,

I am trying to draw charts in excel such that it need to show one background colour upto certain time value and then other colour after that value.

Like if i have the below data

X- Axis || Y-AXIS
Jan || 10
Feb || 12
Mar || 5
Apr || 7
May || 25

I want to show the graph in one background colour in chart upto March and then in other colour after March

 

[Smallman]

Hi Sukesh

By Background Colour do you mean the colour of the series. There is only one background as far as I know but you can change the series colour at a certain point and if you are smart about it this point can be dynamic.

Take care

Smallman

 

[Hui]

Sukesh

Firstly, Welcome to the Chandoo.org Forums



See attached file: