Let me try and explain
I want to have a few line graphs on a spread sheet.
The first I want is 5 different lines and capture the data from row 110 (Period Total) which is a running total of the below
ACTUAL (C105:109) , FORECAST (D105:109) , VS BUDGET (E105:109) , VS LFL (F105:109) & VS OTHER VENUE (G105:109)
Time frame would be B105:B109 which is a period total of 4 or 5 weeks.
Screenshot 2022-03-20 at 17.35.04.png
Once I understand this I will replicate 12 times and have a Total 12 month table
Hope this makes sense
Bookmarks