Chart, Formatting X-axis

[shahyar]

Hi,
I have such data:
X Y
1.1 4
1.7 3
2.2 2

I like to have a chart with these numbers on its X-axis: 0 1 2 3 ...(and not 1.1, 1.7. 2.2 ..)
How can I do that?

Thanks

 

[MintJulep]

Right click on the axis and select "format axis..."

Play with the major and minor units.

 

[rb1957]

chart using a "line" plot, rather than a "scatter" plot ... this converts the x co-ordinate into "categories" rather than numbers

 

[Zoobie]

It sounds like you might be using line chart instead of an XY (scatter) plot. If you want the x-axis in integers (instead of something like 0.5,1.0,1.5,etc) than you will have to do as MintJulep suggests.

 

[shahyar]

WOw! So quick
Thank you.
Actually I was in "line" type of curve, but now I changed it to Scatter, and it works.
But, the other problem!
I can't see any curve, There are just some "points"!
Thank you again guys.
My supervisor push me to that before long weekend.

 

[Zoobie]

In the Chart Wizard there are 5 sub-types to select from (points, points&lines, just lines, etc.). Alternatively you can double-click on the data series on the chart and select the 'Patterns' tab. Here you can put in lines, change the marker types and make them all sorts of pretty colors.