Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nevs
 
Posts: n/a
Default 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


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

  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default Custom Line Graph on 2 axes help

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




  #3   Report Post  
nevs
 
Posts: n/a
Default Custom Line Graph on 2 axes help


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


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

  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default Custom Line Graph on 2 axes help

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




  #5   Report Post  
nevs
 
Posts: n/a
Default Custom Line Graph on 2 axes help


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


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
complete a line in the middle of a graph to meet both X and Y axes Naveen Charts and Charting in Excel 0 October 17th 05 08:22 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Custom Chart: Stacked Bar & Line Jim Garman Charts and Charting in Excel 1 March 27th 05 01:29 AM
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 05:42 AM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"