Screenshot 2022-04-07 132442.png
The picture itself makes sense as a process, but not chart-wise unless you filter by location. I've attached the actual spreadsheet. View that, and filter by location (col J) then the chart will also make sense.
The problem :
The data comes to me as in location 1. I wish to chart it like at location 3.
But I first have to re-structure it as shown in location 2 before I can chart it like at location 3.
This is mainly due to the dates (2/3, 2/10, 2/17) not being included on the same row as the corresponding numbers in location 1.
Is there a way, aside from elaborate macros, to move from location 1 directly to location 3 without the intermediary re-structuring?
Thank you.
Bookmarks