Thanks. And how do I get the second axis to work? In other words, by
clicking on the series which I want to convert from column to line, do I
select the custom column-line 2 axes type, and then it knows automatically
that I meant for the column on which I selected to be the line and the second
axis?

Thanks for the further clarification.
--
Boris


"Andy Pope" wrote:

Hi,

Create your own combination chart by starting with a clustered column
chart. Then right click the column series you wish to change to a line.
From the context menu pick Chart Type. Choose the appropriate line chart.

Cheers
Andy

BorisS wrote:
Need a custom chart with 2 vertical bars side by side, on one axis, and a
line on a second axis. Anyone know the series of steps I need? I was having
trouble figuring out the order of what set of the three data goes where, and
how to define which of the pieces is on bar and which is on line, and which
is second axis, etc.

Thanks for any help.