Combination chart - want only ONE series showing as a line, not 2.

[Guest]

I want to create a combination chart, on one axis, with 4 series showing in
columns and one in a line.

When I choose the Line-Column chart option, it plots the last two series as
a line and the first three in columns. How can I change the one series to
show as a column like the others?

Thanks very much in advance for your help.

 

[Andy Pope]

Hi,

Rather than use the built-in combination charts roll your own.
Start with a 5 series column chart and then select the series that you
want as a line chart. Right click it and pick Chart Type from the popup
menu. From the chart type dialog pick the required Line chart.

Cheers
Andy