3,580 reputation
11028
bio website beavercreekfire.org
location Beavercreek, Ohio
age 43
visits member for 2 years, 3 months
seen 11 hours ago

I'm a fire chief looking to use some of the huge amounts of data we collect/report to help make better decisions for service delivery.


1d
comment How to plot complex data as a radar chart in MS Excel?
Welcome to Superuser. Two things: to post something (since you don't have enough reputation yet), the best way is to upload it to a filesharing site (like dropbox) and provide a link. Usually, someone here will grab the file and add it to your question for you. Second, Radar Charts are notoriously difficult to read/interpret. Unless that's an industry standard for you, there's probably a better way. Can you give a little more detail about what "trend" you're looking to explore/explain?
2d
revised Excel: How to Superimpose 2 Stacked Column Charts
additional example
2d
revised Excel: How to Superimpose 2 Stacked Column Charts
additional image
2d
comment Excel: How to Superimpose 2 Stacked Column Charts
Ok, I'll work on a description, but I probably can't get to it today. Basically, it's a cheat. Two identically formatted charts, one for each phase, overlaid. It may be possible in a single chart, but I'll have to work through the mechanics.
Jul
9
comment Excel: How to Superimpose 2 Stacked Column Charts
Ok, I think I understand the problem a bit better. Is the third image (I modified it) similar to what you're looking for? With the area of emphasis on the blue/red overlap in the middle?
Jul
9
revised Excel: How to Superimpose 2 Stacked Column Charts
updated image
Jul
9
comment Excel: How to Superimpose 2 Stacked Column Charts
Your problem is fairly complex (and seems to be related to your previous question?). Is the third image I added to my answer more like you're expecting? What overlap are you trying to emphasize?
Jul
9
revised Excel: How to Superimpose 2 Stacked Column Charts
additional image
Jul
9
revised Excel: How to Superimpose 2 Stacked Column Charts
additional options
Jul
9
comment Excel: How to create a nonuniform stack chart
I don't think there's an easy way to make the borders that way, since Excel is looking at each stacked column as a discrete object. One possible way (but I'm not sure its worth the work) is to use an XY Chart to draw your borders-I just don't think it would be easy to do automatically-you'd probably have to create a custom data set (based on your primary set) with each of the corner coordinates for the XY points, then format them with a visible connecting line.
Jul
9
revised Excel: How to Superimpose 2 Stacked Column Charts
added image
Jul
9
answered Excel: How to Superimpose 2 Stacked Column Charts
Jul
3
comment Excel: How to create a nonuniform stack chart
Did that work for you?
Jul
2
comment Hide columns based on content (sum of rows)
Your row and column references don't match-rows are denoted by numbers and columns by letters. Yet your example references Row E. Please clarify so we can answer your question.
Jul
1
comment Excel: How to create a nonuniform stack chart
Added some directions at the bottom of the answer.
Jul
1
revised Excel: How to create a nonuniform stack chart
updated anser
Jul
1
answered Excel: How to create a nonuniform stack chart
Jul
1
revised Excel: How to create a nonuniform stack chart
reformat data and added image
Jun
30
comment Excel: How to create a nonuniform stack chart
Do you have a sample of what you'd like it to look like (to help your description)?
Jun
27
reviewed Close Make excel relate to different values