This does not fit high on my list of program defects. Each axis group is
being plotted appropriately to the category axis it is using. The user
sometimes has to make adjustments to make combinations work out differently
than they are programmed.

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


"scott" wrote in message
...
i appreciate "work around", but that is no substitute for a product that
functions properly and allows for one to remove programed assumptions.
however, i still would like for this work, so until the "fix this" (not
holding breath), let's get your suggestion to work.

now, i am using excel 2007 and many of the options here do not seem to
work.
i am receiving the error message "the references is not valid. references
for titles, values, or sizes must be a single cell, row, or column".

"Bernard Liengme" wrote:

Look here and all your worries are over
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"scott" wrote in message
...
I am creating a column chart. I have two sets of data that need to be
compared but with a different vertical axis. When I select "format
data
series" to indicate which sets of columns will utilize the secondary
axis
excel stacks the columns. I have not been able to prevent this. I
won't
go
into how frustrating this has been, let's just stick to a solution.