rockraider
New Member
- Joined
- Jul 21, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
Hi,
Google did not give back any answers for the terms I have looked up, so I guessed this forum might be a good idea.
I am building a dashboard with E-Commerce data, that is updated daily. In the first column, I have the dates and in the rows there is the data from that day.
Every day I will add some more data. Are there any blog articles or best practices how to work with that so conditional formatting and charts get updated once I add more data? Should I just put zeros for data corresponding to future dates or just leave the cells empty?
Best regards?
Google did not give back any answers for the terms I have looked up, so I guessed this forum might be a good idea.
I am building a dashboard with E-Commerce data, that is updated daily. In the first column, I have the dates and in the rows there is the data from that day.
Every day I will add some more data. Are there any blog articles or best practices how to work with that so conditional formatting and charts get updated once I add more data? Should I just put zeros for data corresponding to future dates or just leave the cells empty?
Best regards?