Cluster charts and the secondary y-axis

I'm trying to create a cluster chart with two series' of data but with a
secondary y-axis. Upon clicking on secondary axis (Format Data Series / Axis
/ Plot on secondary axis) it stacks each cluster, meaning each data pair. I
want them to stay side by side, just as they appear when there is only one
axis (ie. no overlap). Once the secondary axis is clicked off, manipulating
the overlap has no effect. I can't seem to separate the pairs.

You need to add some blank dummy series to maintain proper positioning of
the series.

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"8472" <8472@discussions.microsoft.com> wrote in message
news:4D73EA97-278C-4937-A36C-011A2D27E927@microsoft.com...
> I'm trying to create a cluster chart with two series' of data but with a
> secondary y-axis. Upon clicking on secondary axis (Format Data Series /
> Axis
> / Plot on secondary axis) it stacks each cluster, meaning each data pair.
> I
> want them to stay side by side, just as they appear when there is only one
> axis (ie. no overlap). Once the secondary axis is clicked off,
> manipulating
> the overlap has no effect. I can't seem to separate the pairs.