MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graph - axis (No reply ??????)


Posted by Stephen W Allenberg on February 04, 2002 6:05 PM


I have created a graph of the equation i=a/(t+b)^c
and the Y axis values (i)-(vertical)are fine however I wish to change the X axis values (t) - horizontal values to read from zero to a certain value (constant increment) which will be the entered value ie 0, 10, 20 etc and not the numerical entry ie first entry - 1, second - 2, etc etc

Regards
Stephen


Posted by Nib on February 04, 2002 7:23 PM

Double click on your value axis, select scale, insert your constant increment in the major unit box eg 10 and your highest value in the maximum box eg 100, your x axis on your graph will then read 0,10,20,30 etc

Posted by Stephen Allenberg on February 05, 2002 5:45 AM

Re: Graph - axis (X axis - not Y axis)


I have done what you have suggested, however this only seems to work on the Y Axis (not the X axis)which does not have the same criteria to select



I have created a graph of the equation i=a/(t+b)^c
and the Y axis values (i)-(vertical)are fine however I wish to change the X axis values (t) - horizontal values to read from zero to a certain value (constant increment) which will be the entered value ie 0, 10, 20 etc and not the numerical entry ie first entry - 1, second - 2, etc etc


Posted by Nib on February 08, 2002 9:37 PM

Re: Graph - axis (X axis - not Y axis)

Sorry I misunderstood you..... use a X-Y scatter chart, you WILL be able to alter the values on both the X and Y axes.