chart: Y meets the value of X

[Merbman]

Probally an easy question but for me a real struggle. Why is it that my x values in a graph, are not meeting the y values were they belong. Is there a simple trick?? Thanx anyway

 

[Dave Hawley]

Hi

Right click on the "Y" axis, select "Format axis" click the "Scale" tab and see if the "Catergory (x) axis crosses at" is checked and the value. According to the help:

Type a value in the Category (X) axis crosses at box to specify the value at which you want the category (x) axis to cross the value axis. Selecting the Auto check box causes the category (x) axis to cross the value axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).