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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top