Excel - Chart Question

[DaddyTorgo]

If I have a chart with 2 values and I want to overlay one on top of the other, how can I make the bar that's going to be overlaid on top (that is in all cases shorter) have less height than the underlying bar (so the overlay bar looks like it's inside).

I know it CAN be done - I'm trying to recreate a chart. Only, for the life of me, I can't figure out what settings they used to make it look that way.

I literally just went into the chart I'm trying to replicate and deleted the values and put in my new values, but somehow when I do that it "breaks" the appearance of the inside bar being less tall.

[Suburban Rhythm]

Can you screen shot?

I've seen side by side, usually in terms of a quarterly budget next to quarterly actual, but not sure I've ever seen one "inside".

Also, are you certain they aren't stacked?

[DaddyTorgo]

They could very well be stacked, but if they're stacked (which is totally an option) how do I make the "inside bar" have a different width (or appear to have a different width) than the "outside bar?"

I can screenshot...I can email you the excel file...sure.

Now I've got it to the point where there is one bar "inside" another, but it's hidden behind the second one so you can't even see it.

Here's the original.

[DaddyTorgo]

I thought they were stacked initially, but I couldn't figure how to make the inside one appear "thinner" in a stacked chart, so maybe they're not? I dunno. It definitely all comes out of one excel sheet - I have the excel sheet that the original chart is in with the chart and all.

[Bobble]

Can you do it with line widths on the "lower bars"? Bump that up to 5 pt or so to make it look wider?

[DaddyTorgo]

Originally Posted by Bobble

Can you do it with line widths on the "lower bars"? Bump that up to 5 pt or so to make it look wider?

lower?

line widths...hmm...interesting idea.

[DaddyTorgo]

SR wins. I should buy him a present. I'm not sure how he did it - hopefully he tells me, but he basically replicated it.

[Bobble]

Originally Posted by DaddyTorgo

SR wins. I should buy him a present.

Damn! (In my best James Kirk, Wrath of Khan voice complete with fist shake) SUBURBAN RHYTHM!!!!!!!

[Suburban Rhythm]

Originally Posted by DaddyTorgo

SR wins. I should buy him a present. I'm not sure how he did it - hopefully he tells me, but he basically replicated it.

I can't take full credit. DT was pretty much on his way to solving. I just tweaked it a little.

The spread between values on the on the lower Y axis changed pretty significantly compared to the original. Because the original max was 100%, those bars were short by comparison. I adjusted the values to just above the highest value (37%)...and BOOM.

[Suburban Rhythm]

Originally Posted by DaddyTorgo

SR wins. I should buy him a present.

DOLA


Go to a game at TD in a Crosby jersey next fall...

[DaddyTorgo]

Originally Posted by Suburban Rhythm

DOLA


Go to a game at TD in a Crosby jersey next fall...

So you want me to die? If I do that - this post will be introduced as evidence at your trial!

[DaddyTorgo]

Originally Posted by Suburban Rhythm

I can't take full credit. DT was pretty much on his way to solving. I just tweaked it a little.

The spread between values on the on the lower Y axis changed pretty significantly compared to the original. Because the original max was 100%, those bars were short by comparison. I adjusted the values to just above the highest value (37%)...and BOOM.

Still - I never thought to look at the Axis values (maybe because I was sort of hoping to leave 100% in there so that the absolute-lowness of the correlations stood out). I'll be damned if that wasn't the solution though!