software

I want to create a column chart that has one data series on the left axis,
and the other series on the right axis. Pretty easy if you want the 2nd axis
to be a line, but can't figure out how to do this with a column.

Hi,

You need to stagger your data to stop the 2 sets of columns overlapping
each other.
See here for information.
peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

dguilbault wrote:
gt; I want to create a column chart that has one data series on the left axis,
gt; and the other series on the right axis. Pretty easy if you want the 2nd axis
gt; to be a line, but can't figure out how to do this with a column.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

I have worked out how to do it but unfortunately my two columns sit over/in
front of/behid each other rather than side by side.

quot;dguilbaultquot; wrote:

gt; I want to create a column chart that has one data series on the left axis,
gt; and the other series on the right axis. Pretty easy if you want the 2nd axis
gt; to be a line, but can't figure out how to do this with a column.

Andy seems to have copied the wrong link. Try this:

peltiertech.com/Excel/Charts/...OnTwoAxes.html

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

quot;dguilbaultquot; gt; wrote in message
...
gt;I want to create a column chart that has one data series on the left axis,
gt; and the other series on the right axis. Pretty easy if you want the 2nd
gt; axis
gt; to be a line, but can't figure out how to do this with a column.
Doh!

Thanks Jon. I have also posted the correct link to the other post I have
used it in.

Cheers
Andy

Jon Peltier wrote:
gt; Andy seems to have copied the wrong link. Try this:
gt;
gt; peltiertech.com/Excel/Charts/...OnTwoAxes.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;dguilbaultquot; gt; wrote in message
gt; ...
gt;
gt;gt;I want to create a column chart that has one data series on the left axis,
gt;gt;and the other series on the right axis. Pretty easy if you want the 2nd
gt;gt;axis
gt;gt;to be a line, but can't figure out how to do this with a column.
gt;
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info