How do I add a trend line for only half of my graph?

S

Shannon K.

I have a line graph that plots a series of data for months Jan-Nov. I only
want to add a trendline to the second half of the data on the graph. Example,
I only want a trendline from June-Nov, but I want the whole Jan-Nov series
plotted as one line on the graph.

How do I add a trendline for only half of the data? Do I need to create 2
series on the graph? And if so, how do I do this in a way that both series
are as one continuous line on the graph?
 
B

Bernard Liengme

Yes, you need two series.
To get the continuity you need:
Series A has all the data
Series B has the data for trendline
Make chart; add trendline
Format Series B to have no line or marker OR to have line and marker that
match that of series A
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

Trendline in Stacked Column Chart 2
How do I stop trendline from touching the y-axis? 7
graph column line graph with two axes 1
create hourly graph from half hour data 0
Graph Line Width ? 1
How to add a trendline in Excel 2007 4
Trendline Issues 4
Extrapolation of x value from the trendline of a non-linear graph 1

Top