Trend Lines

T

Tony Williams

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
 
B

Bernard Liengme

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?
 
T

Tony Williams

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
 
T

Tony Williams

It would seem that the trend line for the second Y axis doesn't show???
Tony
 
T

Tony Williams

Think I've cracked it Bernard have to set X axis for second series as well
Tony
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

x-y scatter plots and trend lines 0
changing trend/series data by manipulating chart lines? 1
Creating a Chart on form from selected data in query. 0
Help with area under trendline 0
Trend lines on data subsets 2
Labeling on independently stacked line chart 0
Comparative Scatterplot?? 1
One bar line with two trend lines 1

Top