If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trend Lines
I have a chart with two lines based on two series. They have a different Y
axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
#2
|
|||
|
|||
Trend Lines
I have no problem adding 2 trendlines to an XY chart with two data series
with different axes. What type of chart? Can you give some of the data? -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "Tony Williams" wrote in message ... I have a chart with two lines based on two series. They have a different Y axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
#3
|
|||
|
|||
Trend Lines
Thanks Bernard. Its a simple line chart showing number of visitors on one
line and labour costs on another line both plotted over the last three years. the Y axis for visitors goes from 0 to 300,000 and the Y axis for labour costs goes from 0 to 700. The label appears in the legend but the line doesn't show. In one month in 2001 we had no visitors because we were closed so rather than use a value of 0 I put 1 for that month. Any help? TIA Tony "Bernard Liengme" wrote in message ... I have no problem adding 2 trendlines to an XY chart with two data series with different axes. What type of chart? Can you give some of the data? -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "Tony Williams" wrote in message ... I have a chart with two lines based on two series. They have a different Y axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
#4
|
|||
|
|||
Trend Lines
It would seem that the trend line for the second Y axis doesn't show???
Tony "Bernard Liengme" wrote in message ... I have no problem adding 2 trendlines to an XY chart with two data series with different axes. What type of chart? Can you give some of the data? -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "Tony Williams" wrote in message ... I have a chart with two lines based on two series. They have a different Y axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
#5
|
|||
|
|||
Trend Lines
Think I've cracked it Bernard have to set X axis for second series as well
Tony "Bernard Liengme" wrote in message ... I have no problem adding 2 trendlines to an XY chart with two data series with different axes. What type of chart? Can you give some of the data? -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "Tony Williams" wrote in message ... I have a chart with two lines based on two series. They have a different Y axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
#6
|
|||
|
|||
Trend Lines
What were you trying to accomplish with a 1 instead of a 0 for the month
you were closed? If you want the trendline to ignore it, use #N/A; if not, why not use the actual value? Jerry Tony Williams wrote: Thanks Bernard. Its a simple line chart showing number of visitors on one line and labour costs on another line both plotted over the last three years. the Y axis for visitors goes from 0 to 300,000 and the Y axis for labour costs goes from 0 to 700. The label appears in the legend but the line doesn't show. In one month in 2001 we had no visitors because we were closed so rather than use a value of 0 I put 1 for that month. Any help? TIA Tony "Bernard Liengme" wrote in message ... I have no problem adding 2 trendlines to an XY chart with two data series with different axes. What type of chart? Can you give some of the data? -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "Tony Williams" wrote in message ... I have a chart with two lines based on two series. They have a different Y axis. I can create a trend line for one series but not the other. Anyone help? TIA Tony |
Thread Tools | |
Display Modes | |
|
|