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

S

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.
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gantt chart duration not showing 0
Convert Error Bars to Series and Colour 1
Chart series select. 3
sideways stacked bar charts with line series on the same axis 0
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
multiple series bar and line chart 2
Help with area under trendline 0
One extra x axis item that wont go away - can anyone help? 3

Top