how do I limit trendline data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sinple graph with data for 12 months plus a YTD line. When I set a
trend line it includes the YTD data. How can I only show the trend for the 12
months
 
Plot the 12 months data seperately (i.e., as an additional series).
Now, create a trendline for that series.

--
Regards,

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