bar charts with secondary y axis

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
>