2 Axis Charting with Column and Line Formats

[Rob Uter]

I have a 6 series chart, with two axis'.

The primary axis is in column format, and the secondary
axis is in line format.

I want to add a seventh series (plotted on the secondary
axis). Excel does this but changes the four series to now
be plotted on the primary axis with the column format.

I can change the fourth series to be plotted on the
secondary axis, however it is still displayed in the
column format (and now being plotted in front of, rather
than beside the first three series).

Excel seems to plot the first half of the series in a
column format (which ever axis is on), how can I override
this ?

 

[Jon Peltier]

Rob -

Sometimes it's easier to build the chart yourself than using one of
Excel's built-in combination chart types. Plot all your series on the
chart as a column chart. There will be only a primary axis.

Select one series you want to be a line style, go to Chart Type on the
Chart menu, and change it to a line. In turn, select each of the other
series you want to switch, and press F4 to repeat the action.

Now double-click one of the line series, and on the Axis tab, select
Secondary. In turn, select each of the other line series, and press F4
to repeat the action.

- Jon