 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-27-2005, 07:27 AM
|
|||
|
|||
|
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 
|
|
#2
10-27-2005, 09:05 AM
|
|||
|
|||
|
Re: 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 > > >
|
|
#4
10-27-2005, 10:05 AM
|
|||
|
|||
|
Re: 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 >> >> >> >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
