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??

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/ChartsH...sterStack.html

Cheers
Andy

John Espinoza wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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


John

"Andy Pope" wrote:

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/ChartsH...sterStack.html

Cheers
Andy

John Espinoza wrote:
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, Microsoft MVP - Excel
http://www.andypope.info