Stacked isn't a good way to show actual and planned. How do you compare them
if they aren't adjacent?
I would use a clustered chart, with two primary and two secondary series.
You have to use empty series to make them not overlap each other:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Max" wrote in message
...
Hi,
I want top create a graph for 2 types of utilities. Per utility, I want it
to demonstrate on the primary axis the available # of that utility,
stacked
for actual and planned.
On the secondary axis, I want it to show the Power of these utilities,
again
stacked in actual and planned.
So I need 4 stacked columns over 2 axis and in 2 categories over the
X-axis.
Would be very helpful, thanks!
Max