proper scaling in chart (with time-scale X-axis)

[Edward]

I have a chart with the following data:

x y
- -
1 1
1.25 1.25
2 2
3 3
5 5

I expect to see a chart with a straight line graph. The only way I
can get the X-axis to scale is to go into Chart Options->Axis-

Category (X) axis->Time-Scale and then format the X-axis as a number

as opposed to a date. However, this still treats my data as dates so
that 1 and 1.25 show up on the same point on the X-axis (1). Is there
any way to "number" scale my X-axis or some other approach to
accomplish this goal of my X-axis scaling along with the values?

Thanks.

Edward

 

[bj]

use the xy chart rather than the line chart

I have a chart with the following data:

x y
- -
1 1
1.25 1.25
2 2
3 3
5 5

I expect to see a chart with a straight line graph. The only way I
can get the X-axis to scale is to go into Chart Options->Axis-
as opposed to a date. However, this still treats my data as dates so
that 1 and 1.25 show up on the same point on the X-axis (1). Is there
any way to "number" scale my X-axis or some other approach to
accomplish this goal of my X-axis scaling along with the values?

Thanks.

Edward

 

[Edward]

use the xy chart rather than the line chart







- Show quoted text -

Thanks!