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

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" <tw@tcp.invalid> wrote in message
news:c05dtu$ea7$1@hercules.btinternet.com...
> 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
>
>

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" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:eHiDPmk7DHA.2404@TK2MSFTNGP11.phx.gbl...
> 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" <tw@tcp.invalid> wrote in message
> news:c05dtu$ea7$1@hercules.btinternet.com...
> > 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
> >
> >
>
>

It would seem that the trend line for the second Y axis doesn't show???
Tony
"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:eHiDPmk7DHA.2404@TK2MSFTNGP11.phx.gbl...
> 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" <tw@tcp.invalid> wrote in message
> news:c05dtu$ea7$1@hercules.btinternet.com...
> > 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
> >
> >
>
>

Think I've cracked it Bernard have to set X axis for second series as well
Tony
"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:eHiDPmk7DHA.2404@TK2MSFTNGP11.phx.gbl...
> 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" <tw@tcp.invalid> wrote in message
> news:c05dtu$ea7$1@hercules.btinternet.com...
> > 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
> >
> >
>
>

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" <bliengme@stfx.TRUENORTH.ca> wrote in message
> news:eHiDPmk7DHA.2404@TK2MSFTNGP11.phx.gbl...
>
>>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" <tw@tcp.invalid> wrote in message
>>news:c05dtu$ea7$1@hercules.btinternet.com...
>>
>>>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
>>>
>>>
>>>
>>
>
>