how do I limit trendline data

J

Johnj_911

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
 
T

Tushar Mehta

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
 

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
Creating a Chart on form from selected data in query. 0
Trend lines on data subsets 2
remove "linear" from trendline legend entry 2
Trendline partial data 2
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
Move Data Series Manually 4
Charting information from nultiple work books 3

Top