I have a chart with each week of the year for 2015. As the weeks fill with data I would like to have a trend line based on what is there already, how can I get Excel to ignore weeks that have not accrued yet? Even a few weeks left in this year makes a trend line look bad. Thanks