X-Axis Frustration

[Dave]

Should be a simple graph - but!!!

A typical plot that I just can't make work would be for the following simple
data for various aircraft:

X-Axis values (cruise speed - mph) - 315 325 355 520 and
555
Corresponding Y-Axis Values (mpg) - 0.4 1.11 0.52 0.25
and 0.11

Couple of questions:

1) How do I get even increments of cruise speed on the x-axis, say 0 to
600, in even 100 increments, with data points properly spaced?

2) What is the real difference between Chart Options of Category and
Automatic?

Dave

 

[Bernard Liengme]

By making an XY chart not a Line chart
If only the name 'Line' had never been used, we would all of been happier
An XY chart can also display lines or just markers or both
Whenever the x-values are actual numbers (no ordinals like house numbers) it
is always wise to use an XY chart
best wishes

 

[Dave]

My word - thank you Bernard -

I have been beating on Line charts for years, and they have been driving me
nuts. Guess I should have tried the XY thing.

Thanks immensely - much appreciated

Dave