software

I have tried to enter some simple data, consisiting of height and weight
variables onto a scattergraph and have formatted the cells as quot;numbersquot;:

Height Weight
1.56 53.00
1.52 40.00
1.42 41.00
1.61 45.00
1.62 47.00

The problem is that on the finished chart, the weight scale starts at 0 and
goes to 60 and it does this regardless of which axis I put the data on.

The Chart Wizard does not allow me to choose anything other that Automatic
for the Value (X) axis as this section is unhighlighted. All I can do is
unselect the Value (X) axis.

I have tried clicking on the X axis of the finished chart and altered the
minimum value to 30 under the Scale tab, but when I click OK there is no
change. On checking I find that the minimum value under the Scale tab is
still set at 0.

Any help and advice would be much appreciated.

Many thanks

Martin Coates

Have you really made an XY chart or did you mistakenly make a Line chart?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;The Head Gardenerquot; lt;The Head gt; wrote in
message ...
gt;I have tried to enter some simple data, consisiting of height and weight
gt; variables onto a scattergraph and have formatted the cells as quot;numbersquot;:
gt;
gt; Height Weight
gt; 1.56 53.00
gt; 1.52 40.00
gt; 1.42 41.00
gt; 1.61 45.00
gt; 1.62 47.00
gt;
gt; The problem is that on the finished chart, the weight scale starts at 0
gt; and
gt; goes to 60 and it does this regardless of which axis I put the data on.
gt;
gt; The Chart Wizard does not allow me to choose anything other that Automatic
gt; for the Value (X) axis as this section is unhighlighted. All I can do is
gt; unselect the Value (X) axis.
gt;
gt; I have tried clicking on the X axis of the finished chart and altered the
gt; minimum value to 30 under the Scale tab, but when I click OK there is no
gt; change. On checking I find that the minimum value under the Scale tab is
gt; still set at 0.
gt;
gt; Any help and advice would be much appreciated.
gt;
gt; Many thanks
gt;
gt; Martin Coates
Yes, on Chart Wizard I clicked on XY (Scatter) and then Chart sub-type
quot;Scatter, Compares pairs of values.quot;, this is the one with no lines joining
the points.

quot;Bernard Liengmequot; wrote:

gt; Have you really made an XY chart or did you mistakenly make a Line chart?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;The Head Gardenerquot; lt;The Head gt; wrote in
gt; message ...
gt; gt;I have tried to enter some simple data, consisiting of height and weight
gt; gt; variables onto a scattergraph and have formatted the cells as quot;numbersquot;:
gt; gt;
gt; gt; Height Weight
gt; gt; 1.56 53.00
gt; gt; 1.52 40.00
gt; gt; 1.42 41.00
gt; gt; 1.61 45.00
gt; gt; 1.62 47.00
gt; gt;
gt; gt; The problem is that on the finished chart, the weight scale starts at 0
gt; gt; and
gt; gt; goes to 60 and it does this regardless of which axis I put the data on.
gt; gt;
gt; gt; The Chart Wizard does not allow me to choose anything other that Automatic
gt; gt; for the Value (X) axis as this section is unhighlighted. All I can do is
gt; gt; unselect the Value (X) axis.
gt; gt;
gt; gt; I have tried clicking on the X axis of the finished chart and altered the
gt; gt; minimum value to 30 under the Scale tab, but when I click OK there is no
gt; gt; change. On checking I find that the minimum value under the Scale tab is
gt; gt; still set at 0.
gt; gt;
gt; gt; Any help and advice would be much appreciated.
gt; gt;
gt; gt; Many thanks
gt; gt;
gt; gt; Martin Coates
gt;
gt;
gt;

I had no trouble getting a range of 30 to 55 on the y-axis
Write to my private email and I will send you a file
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;The Head Gardenerquot; gt; wrote in
message ...
gt; Yes, on Chart Wizard I clicked on XY (Scatter) and then Chart sub-type
gt; quot;Scatter, Compares pairs of values.quot;, this is the one with no lines
gt; joining
gt; the points.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Have you really made an XY chart or did you mistakenly make a Line chart?
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;The Head Gardenerquot; lt;The Head gt; wrote
gt;gt; in
gt;gt; message ...
gt;gt; gt;I have tried to enter some simple data, consisiting of height and weight
gt;gt; gt; variables onto a scattergraph and have formatted the cells as
gt;gt; gt; quot;numbersquot;:
gt;gt; gt;
gt;gt; gt; Height Weight
gt;gt; gt; 1.56 53.00
gt;gt; gt; 1.52 40.00
gt;gt; gt; 1.42 41.00
gt;gt; gt; 1.61 45.00
gt;gt; gt; 1.62 47.00
gt;gt; gt;
gt;gt; gt; The problem is that on the finished chart, the weight scale starts at 0
gt;gt; gt; and
gt;gt; gt; goes to 60 and it does this regardless of which axis I put the data on.
gt;gt; gt;
gt;gt; gt; The Chart Wizard does not allow me to choose anything other that
gt;gt; gt; Automatic
gt;gt; gt; for the Value (X) axis as this section is unhighlighted. All I can do
gt;gt; gt; is
gt;gt; gt; unselect the Value (X) axis.
gt;gt; gt;
gt;gt; gt; I have tried clicking on the X axis of the finished chart and altered
gt;gt; gt; the
gt;gt; gt; minimum value to 30 under the Scale tab, but when I click OK there is
gt;gt; gt; no
gt;gt; gt; change. On checking I find that the minimum value under the Scale tab
gt;gt; gt; is
gt;gt; gt; still set at 0.
gt;gt; gt;
gt;gt; gt; Any help and advice would be much appreciated.
gt;gt; gt;
gt;gt; gt; Many thanks
gt;gt; gt;
gt;gt; gt; Martin Coates
gt;gt;
gt;gt;
gt;gt;
When you change the minimum to 30, resist the urge to check the box to the
left of the altered value. Checking this box tells Excel to set the value
automatically.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;The Head Gardenerquot; lt;The Head gt; wrote in
message ...
gt;I have tried to enter some simple data, consisiting of height and weight
gt; variables onto a scattergraph and have formatted the cells as quot;numbersquot;:
gt;
gt; Height Weight
gt; 1.56 53.00
gt; 1.52 40.00
gt; 1.42 41.00
gt; 1.61 45.00
gt; 1.62 47.00
gt;
gt; The problem is that on the finished chart, the weight scale starts at 0
gt; and
gt; goes to 60 and it does this regardless of which axis I put the data on.
gt;
gt; The Chart Wizard does not allow me to choose anything other that Automatic
gt; for the Value (X) axis as this section is unhighlighted. All I can do is
gt; unselect the Value (X) axis.
gt;
gt; I have tried clicking on the X axis of the finished chart and altered the
gt; minimum value to 30 under the Scale tab, but when I click OK there is no
gt; change. On checking I find that the minimum value under the Scale tab is
gt; still set at 0.
gt;
gt; Any help and advice would be much appreciated.
gt;
gt; Many thanks
gt;
gt; Martin Coates
Dear Jon

Thank you very much for your reply, which solved my problem and much
hair-pulling!

Yours

Martin Coates

quot;Jon Peltierquot; wrote:

gt; When you change the minimum to 30, resist the urge to check the box to the
gt; left of the altered value. Checking this box tells Excel to set the value
gt; automatically.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;The Head Gardenerquot; lt;The Head gt; wrote in
gt; message ...
gt; gt;I have tried to enter some simple data, consisiting of height and weight
gt; gt; variables onto a scattergraph and have formatted the cells as quot;numbersquot;:
gt; gt;
gt; gt; Height Weight
gt; gt; 1.56 53.00
gt; gt; 1.52 40.00
gt; gt; 1.42 41.00
gt; gt; 1.61 45.00
gt; gt; 1.62 47.00
gt; gt;
gt; gt; The problem is that on the finished chart, the weight scale starts at 0
gt; gt; and
gt; gt; goes to 60 and it does this regardless of which axis I put the data on.
gt; gt;
gt; gt; The Chart Wizard does not allow me to choose anything other that Automatic
gt; gt; for the Value (X) axis as this section is unhighlighted. All I can do is
gt; gt; unselect the Value (X) axis.
gt; gt;
gt; gt; I have tried clicking on the X axis of the finished chart and altered the
gt; gt; minimum value to 30 under the Scale tab, but when I click OK there is no
gt; gt; change. On checking I find that the minimum value under the Scale tab is
gt; gt; still set at 0.
gt; gt;
gt; gt; Any help and advice would be much appreciated.
gt; gt;
gt; gt; Many thanks
gt; gt;
gt; gt; Martin Coates
gt;
gt;
gt;