ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   graphing numerical values on the x-axis (https://www.excelbanter.com/charts-charting-excel/158997-graphing-numerical-values-x-axis.html)

Sam

graphing numerical values on the x-axis
 
I am trying to graph some points with the following values:

x axis value 0 240 1400 1640 1880
y axis value 5445 5831 6247 6599 6810

When I graph them, I would like for the distance on the x-axis to be
proportional to the distance between the x-axis values (for instance, there
would be 240 units of space between points 1 and 2 and 1160 units of space
between points 2 and 3). But the points are coming out at the same intervals
on the graph, with the x-axis labels showing the appropriate value. How can
I get these points to reflect the difference in the x-axis values
graphically? Thanks.


Bernard Liengme

graphing numerical values on the x-axis
 
You need an XY chart not a Line chart.
Do not let the word Line confuse you; an XY chart can have data points
joined by lines
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sam" wrote in message
...
I am trying to graph some points with the following values:

x axis value 0 240 1400 1640 1880
y axis value 5445 5831 6247 6599 6810

When I graph them, I would like for the distance on the x-axis to be
proportional to the distance between the x-axis values (for instance,
there
would be 240 units of space between points 1 and 2 and 1160 units of space
between points 2 and 3). But the points are coming out at the same
intervals
on the graph, with the x-axis labels showing the appropriate value. How
can
I get these points to reflect the difference in the x-axis values
graphically? Thanks.




Sam

graphing numerical values on the x-axis
 
Perfect - thank you very much!

"Bernard Liengme" wrote:

You need an XY chart not a Line chart.
Do not let the word Line confuse you; an XY chart can have data points
joined by lines
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sam" wrote in message
...
I am trying to graph some points with the following values:

x axis value 0 240 1400 1640 1880
y axis value 5445 5831 6247 6599 6810

When I graph them, I would like for the distance on the x-axis to be
proportional to the distance between the x-axis values (for instance,
there
would be 240 units of space between points 1 and 2 and 1160 units of space
between points 2 and 3). But the points are coming out at the same
intervals
on the graph, with the x-axis labels showing the appropriate value. How
can
I get these points to reflect the difference in the x-axis values
graphically? Thanks.






All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com