Data visualisation and conditional formatting

[marcvanderpeet12]

Guys,

I have certain data with which I created a graph -> see my attached excel file

Nothing fancy here.

Thing is that I would like to change the colors of the graph bars depending the percentage. So when the percentage is within range 25-35% is must be red, when between 35-50% it must be orange etc...

Is there any clever way to fix this?

Thanks in advance

 

[NARAYANK991]

Hi Marc ,

Have you gone through the technique explained here ?

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

Narayan

 

[Bhawani]

@marcvanderpeet12 please find the enclosed sample file and request you to please share your sample data.
I would like to make it by color how much you want.

@NARAYANK991 thanks for sharing that path

 

[shailluis]

After three weeks of research and experimentation, came the time of doing the final prototype. To do this I used the following concept: the visualisation would be composed of three areas separated by two circles.

 

[shailluis]

Other features can be imagined such as a search engine where you could play with the visualisation according to your interest.

 

[marcvanderpeet12]

Sweet, thanks guys, this was exactly what I was looking for!