Single chart with multiple types (eg lines and columns) possible in Calc?

chosename · June 16, 2021, 9:14am

I created a chart with three series in columns. I would like to change two of them to stacked bars and the third to line. Not found a way to do so. Came from years of Excel in which this is very straight forward. Is this possible in Calc? I did try to look through documentation and searched online under “combination chart types” and “mixed line column chart” but am still stuck. Thanks for your help.

If this is possible, I would also appreciate pointers to how to accomplish this in a macro.

anon73440385 · June 16, 2021, 10:18am

Hello,

Select your 3 data series
Insert -> Chart
Select Column and Line in Choose a Chart Type
Click second icon Stacked Columns and Lines
Click button Finish

image description

Hope that helps.

chosename · June 16, 2021, 11:58am

Thanks. I must be blind not seeing that last option.

chosename · June 16, 2021, 12:07pm

Is there a way to change the line to column and vice versa after making the chart?

anon73440385 · June 16, 2021, 12:28pm

Yes - use Right click -> Data Ranges and the Up and Down arrows to reorder the data series and use Right click -> Chart Type to redo the chart type definition and you may get something like:

The last entry in the **Data Series:** pane seems to constitute the "line".

chosename · June 16, 2021, 2:30pm

thank you so much

Digitus1 · January 25, 2026, 7:50am

I do not get the option to select the number of lines. Any idea why?

Grantler · January 25, 2026, 8:43am

Outdated version?

My version:

Version: 25.8.4.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 4:25.8.4~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded