2nd axis graph

Ket · Jul 20, 2004

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

Jon Peltier · Jul 20, 2004

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/ColumnsOnTwoAxes.html

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

Ket · Jul 21, 2004

Thanks Jon, worked a treat.