Two trend lines on one graph...is this possible

W

WhytheQ

Chart
Y-Axis goes from 0 to 70units
X-Axis goes from 1Jan2006 to 1March2006

What I'd like is 2 trend lines:
Trend line 1 to cover January
Trend line 2 to cover February

The problem is that both trend lines stretch over the whole graph: does
anybody know how to just have Tend line 1 stretching the first half of
the graph and trend line 2 stretching just over February?

Any help greatly appreciated

Regards
Jason.
 
B

Bernard Liengme

You could
a) plot using two data sets : Jan and Feb
OR
b) use TREND on the Jan data and plot it, use TREND on the Feb data and plot
it. Use Copy, Edit|Paste Special to add new data series to existing chart.
best wishes
 

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

One bar line with two trend lines 1
Normalize Graph 8
scatter chart won't accept primary axis 4
Problem creating a logarithmic trend line 2
combining two line charts with different x axis intervals 2
Aligning tick marks and labels on line charts or scatter charts 2
Drawing a 2D graph with Excel 2
Chart trend-line 2

Top