Adding Trendline To Just Some of the Bars in Chart

  • Thread starter Thread starter Carroll
  • Start date Start date
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
 
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
Charts Excel 2003 3
Connect bars in a column chart 4
Trendline partial data start point 1
Trendline partial data 2
Trendline to the Y-Axis 1

Back
Top