Horizontal bars do not align with the data

[GeoTop]

As you can see, the horizontal bars are scattered over the chart like crazy, with several bars hanging over one data entry. What is the reason behind this? I couldn't find a solution to this.

Untitled.jpg

[pjwhitfield]

Sorry but Im not sure what Im looking at? the chart youve posted, looks to be correct? it definitely doesnt look scattered?

if you're talking about the fact that the header on the chart row doesnt line up with the corresponding row on the worksheet then you'd need to resize the chart manually to line it up. Not sure if theres a better way to do that.

[GeoTop]

Hi, this is what I mean, the bars are not aligned to the entry, it doesn't help stretching the chart, it still is messed up with bars showing up in between entriesUntitled.png

[pjwhitfield]

Can you post your workbook? without that its difficult to check what refers to what data.

[GeoTop]

Here it is: http://www.megafileupload.com/7wl2/Sample.xlsx