[Solved] Stacked columns and stacked lines?

Discuss the spreadsheet application

[Solved] Stacked columns and stacked lines?

Postby openso » Wed Apr 01, 2020 11:34 am

Hi,

Using the Stacked columns and line chart, I wondered if there was a built-in way to stack also the lines?
The chart is attached so you can see what I mean. I'd like the lines to be stacked also so I can directly compare to the column.

Thanks for your help!
For the record: LibreOffice 6.0.7.3 on Ubuntu 18.04
Attachments
Stacked_col_chart.png
Chart
Last edited by MrProgrammer on Sat Apr 11, 2020 6:09 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
LibreOffice 6.0.7.3 on Ubuntu 18.04
openso
 
Posts: 2
Joined: Wed Apr 01, 2020 11:21 am

Re: Stacked columns and stacked lines?

Postby FJCC » Wed Apr 01, 2020 4:16 pm

If there is not a way to do that automatically in LibreOffice, which I do not have available at the moment, I would do it manually as sketched in the attached file.
Attachments
DoubleStacked.ods
(16.25 KiB) Downloaded 10 times
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7680
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Stacked columns and stacked lines?

Postby openso » Wed Apr 01, 2020 4:35 pm

Thanks very much FJCC for that which is indeed a solution.
However the data comes from a pivot table and I'm quite lazy so I would like the source table to remain as simple as possible.
Alternatively, I could use getpivotdata() to calculate the stacked lines from the pivot table but I was hoping for something more gracious.
I'll let the thread open a bit longer just in case.
LibreOffice 6.0.7.3 on Ubuntu 18.04
openso
 
Posts: 2
Joined: Wed Apr 01, 2020 11:21 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests