Horizontal bar chart alignment with rows

[xs2deepak]

Hello everyone,

I have been facing this issue for a long time now. I'm trying to align my horizontal bar charts with my data in a particular cell range. Following pictures correctly explain what I want to achieve.

[/URL][/IMG]

[/URL][/IMG]

Would be great if anyone can suggest a possible way through VBA or any add-in because I am finding it very difficult to do the same by trial and error.

Thanks.

 

[RoryA]

I think you could do most of that using the built-in category axis labels, which would be a lot simpler.

 

[xs2deepak]

The main problem is related to alignment of bars within bar chart with the respective data in excel. Linking axis labels is not an issue at all. I've seen a chart tool in Zebra BI which exactly does the same thing with the charts.

Please refer the following snapshot:

[/URL][/IMG]

Is there any way through which I can achieve this combination of data in Excel Tables and corresponding charts.

 

[RoryA]

You could achieve something very similar using conditional formatting data bars.

 

[xs2deepak]

Thanks for the tip, Rory. However, in case of stacked bar charts this option doesn't seem to be viable. Request your views on the same.

 

[RoryA]

I'd go back to using category axis labels.

I think the code to properly align the charts would be quite complicated.

 

[xs2deepak]

Thanks for the response, Rory. Could you please explain on using category axis labels to align table data and bars in bar chart?