software

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 RinehartAdd 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

In article .comgt;,says...
gt; Is it possible to add a trendline to just some of the bars in a chart?
gt; Suppose each bar represents a month, and you wanted to just show a
gt; trendline beginning with a month that wasn't the first month in the
gt; chart. Is this possible?
gt;
gt; Thanks,
gt;
gt; Carroll Rinehart
gt;
gt;

Thank you Tushar.

Carroll