Changing location of axis labels

[JeffM]

Hi

I have a table with negative and positive y-values. The category labels for the horizontal axis are appearing in the middle of the chart. Is there a way to fix this?

[jeffreybrown]

I believe you should attach a sample workbook so we can understand what you are working with.

[JeffM]

Originally Posted by jeffreybrown

I believe you should attach a sample workbook so we can understand what you are working with.

I cannot figure out how to provide a copy of the chart itself.

An example of the basic problem is this.

Qtr 1 Qtr 2 Qtr 3 Qtr 4

A 120 90 50 80
B 20 70 110 70
Delta 100 20 -60 10

If you set up a chart that is a line chart for the three rows above and you want to label the data points as Qtr 1, Qtr 2, etc., those labels show up in the middle of the chart (below the line y = 0 but well above y = - 60) rather than below the bottom axis.

[jeffreybrown]

How about

https://www.extendoffice.com/documen...tive-zero.html

or

http://www.andypope.info/tips/tip002.htm

[JeffM]

Thank you. That was the answer to my question.

Is there a way to give a thanks that ups your standings?

[jeffreybrown]

Your thanks is quite enough.

Happy to hear you have a working solution.