Want to make a clear Chart

[rush2rajen]

Hi Excel Gurus,

I was trying to make a Chart but its looking very ugly in my point of view.
I would request you to kindly help in creating a Chart Dashboard which makes some sense if anyone sees it.


Thanks
Raj

 

[Luke M]

What is the story your chart is trying to say? Do we need to compare each Centre Name, or would they really be independently analyzed? Similarly, are we comparing each item in B against each other, or are they independent.

Here's two alternative visuals I would suggest:
Dot Plot
http://peltiertech.com/Excel/ChartsHowTo/PanelChart1.html
Trellis Plot
http://www.forbes.com/sites/naomiro...-alternative-to-three-dimensional-bar-charts/

Sadly, neither one is built into XL, but it can be created as a Custom chart. Takes a bit of setup, however. Let us know what you think.