Urgent help need with axis not starting at zero, but labels do need to start at zero

[JacquelineMM]

Hi everyone,

I have a question regarding a horizontal stacked bar chart that I am building. I have my various categories on the Y-axis and my total numbers on the X-axis. The problem is that my horizontal axis has to start at -5 and end at 160. However, I want my horizontal axis labels to start at 0 with intervals of 50 (so denoting 0, 50, 100 and 150). I have been trying to find a solution to this, but whatever I do, my axis labels always start at -5 instead of zero. Please help! Need it for a presentation tomorrow!

Thanks a million!

Jacqueline

P.S. I found some more manual alternative solutions online by adding another line chart and using that to simulate the data points on the axis, but haven't been able to do that in my horizontal stacked bar chart.