I'd like to set up a stacked bar chart with 2 sets of "volume" data and a
corresponding set of $ values (Excel 2003). Ex:
Vol Units1 Vol Units2 $Value
Stuff1 10 2 5000
Stuff2 25 5 12500
Stuff3 15 3 7500

Stacked bar is required to show Volumes in Units1, Units2 and corresponding
Value of each type of Stuff; and the total Volumes and Value of all the Stuff.

Since the Volume amounts are reasonably close they can be plotted against
the same Y axis, but since $ values are large compared to the volumes, this
set needs to be on a secondary axis; which has me stumped (I've tried
numerous times with no luck). I could cheat and use $000's etc but 'd prefer
not to if possible.

Any suggestions would be greatly appreciated.

Cheers

Hi,

See Jon's blog on Cluster/Stacked charts
http://peltiertech.com/WordPress/clu...column-charts/

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ralph c." <ralph wrote in message
...
I'd like to set up a stacked bar chart with 2 sets of "volume" data and a
corresponding set of $ values (Excel 2003). Ex:
Vol Units1 Vol Units2 $Value
Stuff1 10 2 5000
Stuff2 25 5 12500
Stuff3 15 3 7500

Stacked bar is required to show Volumes in Units1, Units2 and
corresponding
Value of each type of Stuff; and the total Volumes and Value of all the
Stuff.

Since the Volume amounts are reasonably close they can be plotted against
the same Y axis, but since $ values are large compared to the volumes,
this
set needs to be on a secondary axis; which has me stumped (I've tried
numerous times with no luck). I could cheat and use $000's etc but 'd
prefer
not to if possible.

Any suggestions would be greatly appreciated.

Cheers