Line graph X-axis
Hello
I am trying to plot the following points on a default line graph: X Y 20.09 25.91 54.19 214.73 85.30 601.00 116.80 2473.33 The chart that Excel is generating is shifting the X-axis out of scale (i.e. its showing the same distance between the points 25.91 and 214.73 that it is between 601 and 2473.33), whereas I would like a uniform scale on this axis (i.e. I would like the x-axis to show 0,500,1000,1500,2000,2500, but with the points listed above still plotted at their appropriate locations). I can alter the max / min of the y-axis by clicking "format axis"; but this option appears to be disabled on the "format X-axis" tab. Is there a way around this? Regards |
Line graph X-axis
A common error - you are making a LINE chart when what is needed is an XY
chart. The terminology 'Line" chart is sooooo misleading! A line chart is used when the x-values are categories; an Xy is used when the x-values are real numbers. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Gary T" wrote in message ... Hello I am trying to plot the following points on a default line graph: X Y 20.09 25.91 54.19 214.73 85.30 601.00 116.80 2473.33 The chart that Excel is generating is shifting the X-axis out of scale (i.e. its showing the same distance between the points 25.91 and 214.73 that it is between 601 and 2473.33), whereas I would like a uniform scale on this axis (i.e. I would like the x-axis to show 0,500,1000,1500,2000,2500, but with the points listed above still plotted at their appropriate locations). I can alter the max / min of the y-axis by clicking "format axis"; but this option appears to be disabled on the "format X-axis" tab. Is there a way around this? Regards |
All times are GMT +1. The time now is 12:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com