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: weekly stacked chart

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.