Custom Line Graph on 2 axes help

hi, i have a chart that i have to make, which included 1 x axis and 2 y axis on it, so i am using the custom line graph on 2 axes profile on excel, the problem is though when i add more series to the chart , the second y axis on the right hand side of the chart suddenly changes scale similiar to the the number 1 y axis, but i dont want this to happen what do i do to fix this,

this is the data i have for the chart

x axis data =
0
6
12
18
24
30
36
42
48
54
60

y 1 axis data=

7050
6240
3890
6670
2030
7620
4710
9860
10010
5910
4320

y2 axis data=
1.1
2.6
3.1
2.4
4.5
0.9
3.5
5.1
5.2
3.7
2.9

and then i add 2 more series into the graph using the following data
s1
13080
12670
10820
10290
6520
7850
6940
9730
9510
4120
5360

s2
6130
5840
5930
4410
1530
3180
2810
4520
6370
5740
3960

now after this is done the second y scale should be from like 0-6 but they dont.?

any help would be nice, thx all

Select the 3rd and 4th data series and Format|Selected Data Series. On
the Axis tab, select Primary axis.

You may want to change your chart type from "Line" to "XY (Scatter)".
The "Line" chart is very misleadingly named; it has nothing to do with
whether you want to connect the data points with lines. The "Line"
chart assumes that x data are category names rather than numbers. If x
data (optional) is specified, then it is plotted with equal spacing in
order of entry (not sort order), which may be totally wrong if they
really are numeric. Y data of subsequent series are plotted
positionally, not by matching x values. Since your x axis data is
equally spaced and each y series contains exactly 11 values, in this
case the "Line" chart may be doing the right thing by accident,
providing that you do not want to fit trendlines. Since the "Line"
chart does not consider your x axis labels to be numbers, a trend line
would assume that the x data is 1,2,3,4,5,6,7,8,9,10,11 instead of the
values you specified.

Jerry

nevs wrote:

> hi, i have a chart that i have to make, which included 1 x axis and 2 y
> axis on it, so i am using the custom line graph on 2 axes profile on
> excel, the problem is though when i add more series to the chart ,
> the second y axis on the right hand side of the chart suddenly changes
> scale similiar to the the number 1 y axis, but i dont want this to
> happen what do i do to fix this,
>
> this is the data i have for the chart
>
> x axis data =
> 0
> 6
> 12
> 18
> 24
> 30
> 36
> 42
> 48
> 54
> 60
>
> y 1 axis data=
>
> 7050
> 6240
> 3890
> 6670
> 2030
> 7620
> 4710
> 9860
> 10010
> 5910
> 4320
>
> y2 axis data=
> 1.1
> 2.6
> 3.1
> 2.4
> 4.5
> 0.9
> 3.5
> 5.1
> 5.2
> 3.7
> 2.9
>
> and then i add 2 more series into the graph using the following data
> s1
> 13080
> 12670
> 10820
> 10290
> 6520
> 7850
> 6940
> 9730
> 9510
> 4120
> 5360
>
> s2
> 6130
> 5840
> 5930
> 4410
> 1530
> 3180
> 2810
> 4520
> 6370
> 5740
> 3960
>
> now after this is done the second y scale should be from like 0-6 but
> they dont.?
>
> any help would be nice, thx all
>
>
>

ok i see where your coming from but im using excel 2000 at the moment which is probably why its so hard to do stuff

You might find it better to use a simple line chart type rather than the
line-on-two-axes custom type, if you stick to a line chart. Then as
Jerry shows how, you double click each series you want on the secondary
axis, and set this on the Axis tab of the dialog. This gives you more
control than you have with the built-in custom type. The same procedure
is what you would use for an XY chart with secondary axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Jerry W. Lewis wrote:

> Select the 3rd and 4th data series and Format|Selected Data Series. On
> the Axis tab, select Primary axis.
>
> You may want to change your chart type from "Line" to "XY (Scatter)".
> The "Line" chart is very misleadingly named; it has nothing to do with
> whether you want to connect the data points with lines. The "Line"
> chart assumes that x data are category names rather than numbers. If x
> data (optional) is specified, then it is plotted with equal spacing in
> order of entry (not sort order), which may be totally wrong if they
> really are numeric. Y data of subsequent series are plotted
> positionally, not by matching x values. Since your x axis data is
> equally spaced and each y series contains exactly 11 values, in this
> case the "Line" chart may be doing the right thing by accident,
> providing that you do not want to fit trendlines. Since the "Line"
> chart does not consider your x axis labels to be numbers, a trend line
> would assume that the x data is 1,2,3,4,5,6,7,8,9,10,11 instead of the
> values you specified.
>
> Jerry
>
> nevs wrote:
>
>> hi, i have a chart that i have to make, which included 1 x axis and 2 y
>> axis on it, so i am using the custom line graph on 2 axes profile on
>> excel, the problem is though when i add more series to the chart ,
>> the second y axis on the right hand side of the chart suddenly changes
>> scale similiar to the the number 1 y axis, but i dont want this to
>> happen what do i do to fix this,
>>
>> this is the data i have for the chart
>>
>> x axis data =
>> 0
>> 6
>> 12
>> 18
>> 24
>> 30
>> 36
>> 42
>> 48
>> 54
>> 60
>>
>> y 1 axis data=
>>
>> 7050
>> 6240
>> 3890
>> 6670
>> 2030
>> 7620
>> 4710
>> 9860
>> 10010
>> 5910
>> 4320
>>
>> y2 axis data=
>> 1.1
>> 2.6
>> 3.1
>> 2.4
>> 4.5
>> 0.9
>> 3.5
>> 5.1
>> 5.2
>> 3.7
>> 2.9
>>
>> and then i add 2 more series into the graph using the following data s1
>> 13080
>> 12670
>> 10820
>> 10290
>> 6520
>> 7850
>> 6940
>> 9730
>> 9510
>> 4120
>> 5360
>>
>> s2
>> 6130
>> 5840
>> 5930
>> 4410
>> 1530
>> 3180
>> 2810
>> 4520
>> 6370
>> 5740
>> 3960
>>
>> now after this is done the second y scale should be from like 0-6 but
>> they dont.?
>>
>> any help would be nice, thx all
>>
>>
>>
>

ahhh now it works, bingo, thx very much for your help, all u have to do is double click on the series and press primary or secondary axis, so simple when u know how aint it

thanks guys