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)
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 :)