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.

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.

thanks. works great.

"Jon Peltier" wrote:

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.