X-Axis Frustration
 

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

X-Axis Frustration
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave" < wrote in message ...
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

X-Axis Frustration
 

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


"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave" < wrote in message ...
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