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

JacquelineMM

New Member
Joined
Apr 10, 2014
Messages
1
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.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,122,160
Messages
5,594,600
Members
413,917
Latest member
devansh02

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top