Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
101
Views
Topic starter
My 12-month trend chart from Nov 2020 to Oct 2021 displays trend from Jan 2020 to Dec 2021 (24 months) when "Show items with no data" and For empty cells show "0" are enabled. Please see the attached sample chart. How can I display only the trend from Nov 2020 to Oct 2021?
Thank you in advance!
Posted : 13/11/2021 12:09 am
Hi Lavan,
Welcome to our forum!
It's not clear why you need Show Items with No Data turned on. It seems pointless to display November and December 2021 in your chart when there is no data for those periods yet.
If you want to force these periods, then you'll need to add rows to your source data for those dates with zeros for each product. When you get actual data for those periods you can remove the zero value rows.
Mynda
Posted : 13/11/2021 5:04 am