ExcelBanter - On a combination chart how do i get 2 lines and 1 column?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - On a combination chart how do i get 2 lines and 1 column? (https://www.excelbanter.com/charts-charting-excel/220-combination-chart-how-do-i-get-2-lines-1-column.html)

On a combination chart how do i get 2 lines and 1 column?

When trying to design a line - column combination chart, if you you add more
than 3 series you are automatically given to column series and one line. Is
it possible to alter this to get 2 lines and one column?

Why don't you just click on the series you want as a line, click on the Chart
menu and choose Chart Type and change it to a line? You could also make your
own user-define line-column chart type from this chart when you have the 2
lines and 1 column, use that to format your charts in future.

Andrea Jones
www.allaboutoffice.co.uk

"Richie" wrote:

When trying to design a line - column combination chart, if you you add more
than 3 series you are automatically given to column series and one line. Is
it possible to alter this to get 2 lines and one column?