Can't align axis (on left) with my stacked bar data

[SallyN]

Hi all,

I got quite far with my stacked bar chart, and I'd be ready if somebody please could help me with a layout issue. The left side (primary vertical axis) wouldn't align with my bars, which means the whole graph is hard to read as you can't see which line/bar belongs to which axis label. Can somebody please help me?? I'm not sure how to upload something here to show you how the graph looks?
thanks sooo much!!!

 

[peterhinton]

try double clicking on the axis,
set axis min/max,

then do the same on the secondary axis,

they will align if they both have same min max,

if the data doesn't allow that, you can alter it so that they are on a same sort of ratio. i.e 1-9 & 10-90

 

[SallyN]

try double clicking on the axis,
set axis min/max,

then do the same on the secondary axis,

they will align if they both have same min max,

if the data doesn't allow that, you can alter it so that they are on a same sort of ratio. i.e 1-9 & 10-90

I have a stacked bar, converged, the data is coming from a survey and the left side axis should be the survey questions. But there is a formula in these question fields instead of only text. Don't seem to be able to change to min/max at this axis. Can change the other axis, as this shows percentages. Never had something strange like this I tried to get an html done but my excel might be too new, the MrExcelHTML doesn't work on my laptop. Would you have any other ideas??