Jesse - make the locations your rows, and the measures the columns, grouped by quarter (I wish I could draw a picture to make this clearer). Then Insert Clustered Bar gives you exactly what you are describing.
ETA: wait, no it doesn't.
{Should I admit that I don't really understand the Angel quote? It never made sense to me. I don't want to be shunned. Like I said, moral philosophy is hard}
{That Gunn quote about not knowing which moment is important, that one I'm into}
Thank you! That is very close. I'm guessing the original wasn't actually made in Excel.
I flipped the axes and got even closer, but I'm now 90% sure the original was made in something more powerful than Excel.
Measures as your rows, 3 quarters for each location as columns, insert column chart.
Like B1=Location 1, E1=Location 2; B2-Q1, C2=Q2, D2=Q3,E2=Q1 etc; A3=Measure1, A4=Measure 2 for labels
There's something more powerful than Excel? (faints)
Why was that more fun than doing my own work (also messing around in Excel)?
ETA although really truly my work right now is "waiting for this report to update so I can use the data"
You totally saved my life!
{Should I admit that I don't really understand the Angel quote? It never made sense to me. I don't want to be shunned. Like I said, moral philosophy is hard}
Here's the whole quote: "If there's no great glorious end to all this, if nothing we do matters...then all that matters is what we do. 'Cause that's all there is. What we do. Now. Today."
Which I took as, if there's no heaven/afterlife, then what we do isn't going to affect whether we end up in heaven or hell. And since all we have is right now, what we do matters, because it affects our here and now.
Steph's reading of that quote is the same as mine.
I am beyond tired and I have one class that actually ruins my day. Not because the kids, but because the class itself BLOWS. And that's my fault (along with the district's fault).
Grr. Argh.
Anyhow, in other news, I just read Nimona and I loved it. Have any of you read it? It would be a good one for Faye who was looking for comic book requests (I think).