HuntingtonM15
New Member
- Joined
- Jun 11, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I have a chart that has monthly data already set up for January through December. The chart gets updated monthly, so for right now, I only need data from January through May. I want my trendline to end exactly where the data ends in May. However, the trendline ends where it should in May and then drops down to zero. How do I prevent the trendline from dropping down to zero instead of ending where the data ends?
I've tried researching this but can only find a few threads from several years ago that are not helping me.
Many thanks in advance!
I have a chart that has monthly data already set up for January through December. The chart gets updated monthly, so for right now, I only need data from January through May. I want my trendline to end exactly where the data ends in May. However, the trendline ends where it should in May and then drops down to zero. How do I prevent the trendline from dropping down to zero instead of ending where the data ends?
I've tried researching this but can only find a few threads from several years ago that are not helping me.
Many thanks in advance!