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


--
nevs
------------------------------------------------------------------------
nevs's Profile: http://www.excelforum.com/member.php...o&userid=28387
View this thread: http://www.excelforum.com/showthread...hreadid=479735