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