column-line charts

[john]

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.

 

[Jon Peltier]

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

 

[john]

thanks. works great.

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
_______