Adding Trendline To Just Some of the Bars in Chart

C

Carroll

Is it possible to add a trendline to just some of the bars in a chart?
Suppose each bar represents a month, and you wanted to just show a
trendline beginning with a month that wasn't the first month in the
chart. Is this possible?

Thanks,

Carroll Rinehart
 
T

Tushar Mehta

Add the desired points as another data series and have XL calculate the
trendline for this series. You can always format the series so that it
appears invisible.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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
average/trendline in chart 3
Trendline in a stacked graph chart 1
Trendline for chart with error bars 2
Trendline partial data 2
Trendline partial data start point 1
Trendline Issues 4
Newbie query about adding trendline 1

Top