how do I change the value of the yaxis to zero in a 3d column graph?

Question

Level 1

0 points

how do I change the value of the yaxis to zero in a 3d column graph?

I am trying to show the difference in a budget. but I can't change the value of my bar graph to start at zero on the yaxis.

it looks funny and I want to make the yaxis start at zero.

Thank you for your time.

MR

Posted on Nov 21, 2015 4:02 PM

Reply

Answer 1

Nov 21, 2015 5:14 PM in response to mrogers88

posting a screenshot of the table of data and the chart will help us help you

Reply

Answer 2

Badunit

Level 7

25,838 points

Nov 22, 2015 5:12 PM in response to mrogers88

I am guessing you have some negative numbers as well as positive numbers in your chart. When you make a chart of that data, the X axis line is going to shoot off from the minimum Y value (at the bottom of the chart), not at Y=0. While you cannot change that behavior, you are able to turn off the X axis line and put a reference line coming off at Y=0. The X axis category labels will still be at the bottom of the chart.

Select the chart
In the Axis tab / Value Y, turn on a reference line. Set it to custom at 0.
Select the reference line and change the weight of it if you think it is too thick
In the Axis tab / Category X, uncheck the box for Axis line.
You might want to put a border around the entire in the chart (which I did not do in the screenshot below. There is a checkbox for the border in the Chart tab.