View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default stacked bars on 2 axes

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