Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scattergraph
I have tried to enter some simple data, consisiting of height and weight
variables onto a scattergraph and have formatted the cells as "numbers": 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scattergraph
Yes, on Chart Wizard I clicked on XY (Scatter) and then Chart sub-type
"Scatter, Compares pairs of values.", this is the one with no lines joining the points. "Bernard Liengme" wrote: 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 "The Head Gardener" <The Head wrote in message ... I have tried to enter some simple data, consisiting of height and weight variables onto a scattergraph and have formatted the cells as "numbers": 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scattergraph
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 "The Head Gardener" wrote in message ... Yes, on Chart Wizard I clicked on XY (Scatter) and then Chart sub-type "Scatter, Compares pairs of values.", this is the one with no lines joining the points. "Bernard Liengme" wrote: 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 "The Head Gardener" <The Head wrote in message ... I have tried to enter some simple data, consisiting of height and weight variables onto a scattergraph and have formatted the cells as "numbers": 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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scattergraph
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 http://PeltierTech.com/ _______ "The Head Gardener" <The Head wrote in message ... I have tried to enter some simple data, consisiting of height and weight variables onto a scattergraph and have formatted the cells as "numbers": 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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scattergraph
Dear Jon
Thank you very much for your reply, which solved my problem and much hair-pulling! Yours Martin Coates "Jon Peltier" wrote: 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 http://PeltierTech.com/ _______ "The Head Gardener" <The Head wrote in message ... I have tried to enter some simple data, consisiting of height and weight variables onto a scattergraph and have formatted the cells as "numbers": 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|