Stacked graph

**jw01** · 04-01-2011, 12:29 PM

hello

having some trouble with a stacked bar graph.

basically, im trying to show 10 sets of data (stacked by 2).

my graphs turns out the way i want, but its not joining together two sets of data graphs.

i have included a sample if someone can please help me out. i have put a "sign" saying what needs to be together. also, i have placed through shapes in "red" a line that runs on only the "projected" data points.

can someone pls help me out, prob take you guys a few seconds. much appreciated. thxs.

**madadd** · 04-01-2011, 12:56 PM

K, here it is. It may not be the same naming scheme, but hopefully you can figure that out.

**jw01** · 04-01-2011, 01:29 PM

hey thxs alot! that works out great.

would you happent to know how to do a 100% stacked graph? i can manage to create it, but my fields aka quota needs to be set at 100%...everything can exceed it. know what i mean?.....can u kindly help with that, thxs
!

**madadd** · 04-01-2011, 02:47 PM

100% stacked graph? Like instead of having $ values you want it out of percent?

**jw01** · 04-01-2011, 03:26 PM

hello

yeah, a 100% stacked graph. however, the issue that im having is that i want to show the quota revenue i.e. 72800$ as my 100% mark adn everything that exceeds it to show over 100%. just struggling with that thxs alot!

**madadd** · 04-01-2011, 03:40 PM

I'm not sure how to do besides doing the percent calculations somewhere and referring to those. See attached

Though if you do the calculations somewhere on the sheet, you could just hide that row or column, wherever it is you decide to do them

**jw01** · 04-01-2011, 04:05 PM

hey

that is exactly what i was looking for, in terms of my projected quota being the 100% mark. great, thxs alot man!

just a quick question, how can i get the names to appear under each bar?....and also, is it possible for the legend to say the person's name? thxs again for your awesome help!

**madadd** · 04-01-2011, 04:37 PM

I can't get both column titles to appear under each stacked set. And you can change the names in the legend, but to have them both be his name, It wouldn't look good. So I think I've identified the general trend and named things on the x-axis and in the legend correctly. Obviously feel free to change it how you wish. Otherwise just right click, and look at the source data to figure out how everything is working.