Thread: Trend Lines
View Single Post
  #3  
Old February 8th, 2004, 02:04 PM
Tony Williams
external usenet poster
 
Posts: n/a
Default 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