Stack charts on 2 axis

[Guest]

Hi,

I am trying to create a stack chart for inventory with 10 series. The first
set of 5 are actual dollar amounts and the second set of 5 are forcast dollar
amounts. What I want to do is have the actual dollar amouts as 1 stack and
the forcast dollar amounts to be a stack next to the actual. Is there a way
to do this?

 

[Jon Peltier]

You don't need them on two axes, just in side-by-side stacks. Look at these
examples:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon