Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Frustration | Excel Discussion (Misc queries) | |||
Dropdown frustration | Excel Worksheet Functions | |||
Date Frustration | Excel Discussion (Misc queries) | |||
Iteration frustration | Excel Discussion (Misc queries) | |||
Help with a read only frustration. | Excel Worksheet Functions |