Help! I have an excel question that I can't quite figure out how to ask, so I can't find the answer myself. Does anyone know how I should arrange my data so that it shows up as a bar chart with two sets of bars? Here is what I have: numbers for each of three quarters in three locations, for two related measures. So I'd like to have each location across the bottom with the three quarters listed for each location, and two bars in each quarter. Does that even make sense? (The problem is that I have a picture of the exact chart I want and no way to update it directly.)
I don't give a good gorram about relevant, Wash. Or objective. And I ain't so afraid of losing something that I ain't gonna try to have it. You and I would make one beautiful baby. And I want to meet that child one day. Period.
Zoe ,'Heart Of Gold'
Natter 73: Chuck Norris only wishes he could Natter
Off-topic discussion. Wanna talk about corsets, duct tape, butt kicking, or physics? This is the place. Detailed discussion of any current-season TV must be whitefonted.
Jesse - May 13, 2015 9:51:38 am PDT #26286 of 30000
Sometimes I trip on how happy we could be.
SailAweigh - May 13, 2015 9:54:07 am PDT #26287 of 30000
Nana korobi, ya oki. (Fall down seven times, stand up eight.) ~Yuzuru Hanyu/Japanese proverb
I think someone yesterday was talking about souls, so I thought I'd share a couple of articles on the subject. I came across the theory in the second article through no less than James Marsters at a panel at a local comic con:
OTOneH, Quantum Theory Won’t Save the Soul.
OTOH, Penrose-Hameroff Theory of Quantum Counciousness
edited second link
tommyrot - May 13, 2015 9:58:43 am PDT #26288 of 30000
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
That second link produces a 404 (not found) error.
-t - May 13, 2015 10:06:03 am PDT #26289 of 30000
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
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}
Jesse - May 13, 2015 10:12:20 am PDT #26290 of 30000
Sometimes I trip on how happy we could be.
Thank you! That is very close. I'm guessing the original wasn't actually made in Excel.
Jesse - May 13, 2015 10:15:44 am PDT #26291 of 30000
Sometimes I trip on how happy we could be.
I flipped the axes and got even closer, but I'm now 90% sure the original was made in something more powerful than Excel.
-t - May 13, 2015 10:17:21 am PDT #26292 of 30000
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
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
Toddson - May 13, 2015 10:17:31 am PDT #26293 of 30000
Friends don't let friends read "Atlas Shrugged"
There's something more powerful than Excel? (faints)
Jesse - May 13, 2015 10:21:48 am PDT #26294 of 30000
Sometimes I trip on how happy we could be.
Ahhh! Thank you!
-t - May 13, 2015 10:23:18 am PDT #26295 of 30000
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
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"