How to do Conditional formatting in Column Charts?

[sreekhosh]

Hi Team,


Please see the uploaded file below,


https://www.dropbox.com/s/bdl0c99xdba1iba/Margin%20Analysis%20Chart.xlsx


In this I need to highlight (chart as dark red) bottom three values of margin.


Thanks


SReeKHosH

 

[NARAYANK991]

Hi Sreekhosh ,


The following links will help :


http://peltiertech.com/WordPress/conditional-formatting-of-excel-charts/


http://excel-example.com/charts/conditional-formatting-in-column-bar-charts


Narayan

 

[sreekhosh]

Thanks for the reply Narayan,


But i already go through these links before posting the same, actually this is a dummy report i just prepared this for posting in our forum only, but in may actual data the margin's range should varying widely so we cannot predict every week, can you please check the sample data i uploaded, in it i need only last three bottom values as in red color.


is there any other solution?


Thanks


Sreekhosh

 

[NARAYANK991]

Hi Sreekhosh ,


I think the principle is that if you want to conditionally format two sections of the chart , you use two series , so that one series will have one color , and the other series will have another color.


Do you want this changed format only for the margin series , or do you want this to be done for all the series ?


Narayan

 

[sreekhosh]

Narayan,


thanks for taking interest, I need only for margin series.


Regards,


Sreekhosh.AP