For simplicity sake, let's say I have this data:
Mon $10
Tue $12
Wed $9
Thu $10
Mon $11
Tue $11
Wed $12
Thu $9
...
I want to create a stacked chart in Google Sheets.
In the first column (labelled WEEK1), I want the values for the first week (MOM-TUE-WED-THU) stacked. In the second column, (labelled WEEK2), I want the values for the second week (MOM-TUE-WED-THU) stacked.
For my needs, every week has exactly 4 days.
And so on and so forth (I have data for the entire year).
Also, I want a line representing the GOAL (in the example, a horizontal line at $400)
Here's a visual representation of what I want to accomplish:
I've been playing with the basic charts in Google Sheets and I believe I'll need to do some magic to prepare the data to be able to accomplish what I need, but I have no idea how to.
Any idea is welcome! Thank you :)
