Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
So back to the Chart.
I have data as below Excel Cells/Rows FA4 to (HZ9 - Random Column)
As there could be any number of stores (e.g. S011) at any time I wanted to make it dynamic.
I am using the following Offset and Counta as a named range (one for each row)
=OFFSET(Dashboard!$FA$6,0,0,COUNTA(Dashboard!$6:$6))
I'm sure I have the offset wrong, any help would be appreciated.
Thanks
I have data as below Excel Cells/Rows FA4 to (HZ9 - Random Column)
As there could be any number of stores (e.g. S011) at any time I wanted to make it dynamic.
I am using the following Offset and Counta as a named range (one for each row)
=OFFSET(Dashboard!$FA$6,0,0,COUNTA(Dashboard!$6:$6))
I'm sure I have the offset wrong, any help would be appreciated.
Thanks
Total | Total | S011 | S011 | S011 | S027 | S027 | S027 | |||
Value% | Wastage% | Value% | LMtr% | Wastage% | Value% | LMtr% | Wastage% | |||
Ambient | 31% | 10% | 27% | 42% | 8% | 34% | 46% | 10% | ||
Confection | 4% | 0% | 4% | 9% | 1% | 4% | 6% | 0% | ||
Drinks | 23% | 5% | 24% | 19% | 5% | 22% | 22% | 38% | ||
Perishables | 39% | 81% | 40% | 30% | 75% | 39% | 27% | 51% |