STACKED "bar-line" chart using two axis?

Originally Posted by FreeBird

I set up a "bar-line" chart using two axis (what's the plural of axis?), but it would be far better if the "bar" portion of the chart used "stacked" bars.

Is this possible? (and if so, how so?)

Thanks in advance for your valuable knowledge!

Hi,

I think http://www.andypope.info/charts/StackColTotal.htm is the chart you're looking for.

hth
---

Hi there Bryan, and thanks for your reply!

What I see in the example is a traditional stacked bar chart on one axis with a total as a data label. What I am looking for the stacked bar on the left axis, and the line (cumulative percentage) on the right axis.

I will look at it again, but I really don't think this is what i'm asking for? You know what though?.. It might work for my purposes. I will take a shot at it, and see if i can make that work.

Thanks again!

Definitely an improvement!!

Originally Posted by FreeBird

Hi there Bryan, and thanks for your reply!

What I see in the example is a traditional stacked bar chart on one axis with a total as a data label. What I am looking for the stacked bar on the left axis, and the line (cumulative percentage) on the right axis.

I will look at it again, but I really don't think this is what i'm asking for? You know what though?.. It might work for my purposes. I will take a shot at it, and see if i can make that work.

Thanks again!

Definitely an improvement!!

Hi,

I figured that you would ignore the 'totals' as not required, and yes, it's looking good.

You could reduce the 'gap width' to give the bars a little more substance.

Did you mean to lose the PC line, or was that accidental?

---