Bug 164111 - RFE: new chart type: 'stacked range'
Summary: RFE: new chart type: 'stacked range'
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2024-11-30 21:23 UTC by Dave Gilbert
Modified: 2025-01-15 09:41 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dave Gilbert 2024-11-30 21:23:41 UTC
Description:
The following video from 'minutephysics' makes the case for a modified stacked barchart they call a 'stacked range':

https://www.youtube.com/watch?v=5zBg9pH_6bE

It looks quite sensible to me.
I *think* it's basically just using the data as absolute Y values rather than summing them
Each colour in the chart runs from that cell value to the next cell value.
The range of a bar is the minimum..maximum values in the range.
There's an assumption I think that the values are sorted (?)

Perhaps this could be implemented with a 'summed' tick box in the barchart UI which defaults to on to give you the current behaviour and unticked to give the new type.

Steps to Reproduce:
1. Enter a column of data like '3,8,12,16,24' and another column -9,3,8,13,27
2. Create a bar chart from the two columns

Actual Results:
The height of each colour in the chart represents a value in the cell

Expected Results:
The lower Y value of each colour in the chart is the value in the cell, the upper Y value is the value in the next cell in the column.


Reproducible: Always


User Profile Reset: No

Additional Info:
charts are pretty.