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

[sincaa]

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

sincaa wrote:
> 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, Microsoft MVP - Excel
http://www.andypope.info