bar charts with secondary y axis

[Guest]

I want to plot # of deliveries and $ by quarter. The # of deliveries needs
to be on the y-axis and the $ need to be on the secondary y-axis. Both
series have the same x-axis data (quarter). I need to have them show up as
bar charts with a gap between range data.

Every time I do it, it just sets one set of data on top of the other.

Is there a better way??

 

[Andy Pope]

Hi,

You need to change the layout of your data in order to offset the
columns. Jon Peltier has a collection of links.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Guest]

Thanks for the help. It was the solution to a lifelong problem!!!


John