Bag the built-in custom chart types. Make a column chart with all of your
data. Select the series you want to change. Go to Chart menu Chart Type,
then select a line type you like. Double click on the new line series, and
on the Axis tab, select Secondary.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"john" wrote in message
...
I understand the default for col-line charts is col on the primary y axis,
line on the secondary axis. I am trying to chart 4 series (columns) onto
the
primary and 1 series (line) onto the secondary axis. The chart wizard
always
starts with placing 3 series onto col / 2 series onto lines. I can change
one of the line series to the primary axis but it still does not format
the
data into a "column" but remains as a "line". any suggestions. Thanks.