Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Graph Axis | Excel Discussion (Misc queries) | |||
How do you drop the line in a line graph? | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Line Graph Problem | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel |