combination column line on 2 axis question

[Art]

The Chart Wizard allows you to plot two columns on the
primary x axis and a line on the secondary x axis. Does
anybody know how to add another column to the primary x
axis and keep the line on the secondary? In other words
three columns and 1 line.

Thanks!!!

 

[Jon Peltier]

Art -

It's easier to dispense with the "built-in custom" types (love that
oxymoron), and create your own. Make a chart with all of the series as
columns. Right click on the one you want to change, select Chart Type
from the pop up menu, and choose a Line type. Now double click on the
series, and on the Axis tab, select Secondary.

- Jon

 

[Art]

Thanks Jon, that works really well and it was easy to do
thanks to your clear explanation!