2nd axis graph

I am running Office/Windows 2K. I have a spreasheet that contains
names of cities. Next to this column I have two sets of data.
I wish to create a bar chart that will plot the city names along the x
axis and then have two y axis to display the 2 different sets of data.
I can create the second y axis, however, this creates a stacking bar
chart which I do not want.
Does anyone know how to do this?

Many thanks.

Regards

Ket

Ket -

What appear as stacking bars are likely two sets of bars, one in front
of the other, instead of side by side. You can make a side by side
column chart on two axes following this example, which uses dummy series
to offset the visible series:

http://peltiertech.com/Excel/Charts...sOnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Ket wrote:
> I am running Office/Windows 2K. I have a spreasheet that contains
> names of cities. Next to this column I have two sets of data.
> I wish to create a bar chart that will plot the city names along the x
> axis and then have two y axis to display the 2 different sets of data.
> I can create the second y axis, however, this creates a stacking bar
> chart which I do not want.
> Does anyone know how to do this?
>
> Many thanks.
>
> Regards
>
> Ket

Thanks Jon, worked a treat.



On Tue, 20 Jul 2004 13:52:44 -0400, Jon Peltier
<DOjonNOTxlmvp@SPAMpeltiertechME.com> wrote:

> http://peltiertech.com/Excel/Charts...sOnTwoAxes.html