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
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).
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.