Forum Discussion
Visualizing measurement and prediction data
lehikk
Please check the attached file. You can select a date and adjust the lower and upper limits to define the date range.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
lehikk
What you are trying to achieve is possible in both ways, either two separate charts or a single chart. I would recommend a single chart option. You can have past 30 days data lets say actuals and next 2 days for predictions, both including today. It can dynamics using dates or periods. Predictions can be highlighted using conditional formatting. based on the dates.
Can you share some sample data to create a solution if you need me to?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Big thanks for offering assistance! Here's some test data for you:
https://www.dropbox.com/s/zg7e3pyvt9kw5fr/testdata.xlsx?dl=1
I simplified it to minimize the number of fields. Please ask if you need anything more.
