chart: Y meets the value of X

Merbman · Mar 12th, 2002, 02:24 AM

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 · Mar 12th, 2002, 02:43 AM

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 (y) axis. Selecting the Auto check box causes the category (x) axis to cross the value (y) axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 02:24 AM	#1
Merbman New Member Join Date: Mar 2002 Posts: 4	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

Mar 12th, 2002, 02:43 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 (y) axis. Selecting the Auto check box causes the category (x) axis to cross the value (y) axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).