Excel Graph Help
http://i43.tinypic.com/2q0k0p5.jpg
Does anybody know how I can recreate this in Excel?
Thanks a lot.
Trending Content - Off Topic Forum
Career Resources
Pretty please someone help me out by Wednesday morning.
We have data for 5 cities. We're trying to show that The sum of 4 cities almost equals the 5th city. So I need a solid bar graph and a staggered bar graph on the same chart.
stacked bar chart with two data sets First will be: #1 - 80,000. #2 - 0. #3 -0. #4 -0. #5 - 0. Second will be: #1 - 0. #2 - 20,000. #3 - 15,000. #4 - 20,000. #5 - 25,000
's don't line up exactly to the pic your showed, but hopefully you get the point.Then put in data labels, but delete all the 0's.
hope this helps.
http://i43.tinypic.com/27xla10.png
Not working. Am I misinterpreting you?
dude it's just a stacked column chart with 1 non-zero series for category 1 and 4 for category 2...
Every way I do it, I get more than 2 columns. How do I make the first column just Berlin and the 2nd on the other 4 cities combined?
Sint laborum consectetur est aliquam nesciunt dolores labore. Quo amet dignissimos natus atque pariatur nam enim. Inventore quas cupiditate ut vero nisi esse.
Ipsa a mollitia eaque laudantium sit aut vitae blanditiis. At deleniti placeat id.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...