Bug 156660 - Implement "Step Chart" in Calc
Summary: Implement "Step Chart" in Calc
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:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-07 18:43 UTC by Rafael Lima
Modified: 2023-08-07 18:44 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Example of step chart (9.03 KB, image/png)
2023-08-07 18:44 UTC, Rafael Lima
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rafael Lima 2023-08-07 18:43:48 UTC
The "step chart" is a common variation of the line chart that we currently do not offer in LO Calc. For example, in quality management the p-control chart draws the control limits using step lines (see attached example).

There are many other data visualization cases (in academia as well as in companies) where the step chart is useful.

For comparison, MS Excel still does not offer this chart by default, and it is very hacky to get a step chart in Excel. See for instance:
https://trumpexcel.com/step-chart-in-excel/

However, I could not make the same hack work in LibreOffice.

Given the usefulness of this chart, we should offer it as a variation of the "Line chart" in the chart wizard.

As for customization options for this chart, I suggest using PyPlot's "step" chart as inspiration.
https://matplotlib.org/stable/api/_as_gen/matplotlib.pyplot.step.html
Comment 1 Rafael Lima 2023-08-07 18:44:26 UTC
Created attachment 188837 [details]
Example of step chart