github-starred/libxlsxwriter

Fork 0

mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 06:06:09 -06:00

[GH-ISSUE #136] Feature request: add defined error bars #111

New issue

Open

opened 2026-05-05 11:41:50 -06:00 by gitea-mirror · 5 comments

gitea-mirror commented

2026-05-05 11:41:50 -06:00

Owner

Originally created by @Nipou on GitHub (Nov 10, 2017).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/136

Originally assigned to: @jmcnamara on GitHub.

The error in science is often different for each measure, so it would be really convenient to be able to define the range of data for the error bars.

So a new type : LXW_CHART_ERROR_BAR_TYPE_DEFINED
And an API void chart_series_set_error_bars_range(lxw_series_error_bars *error_bars, const char *sheetname, lxw_row_t row, lxw_col_t col);

The corresponding XML is simply:

<c:errBars>
<c:errBarType val="plus"/>
<c:errValType val="cust"/>
<c:plus>
<c:numRef>...</c:numRef>
</c:plus>
...

Originally created by @Nipou on GitHub (Nov 10, 2017). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/136 Originally assigned to: @jmcnamara on GitHub. The error in science is often different for each measure, so it would be really convenient to be able to define the range of data for the error bars. So a new type : LXW_CHART_ERROR_BAR_TYPE_DEFINED And an API void chart_series_set_error_bars_range(lxw_series_error_bars *error_bars, const char *sheetname, lxw_row_t row, lxw_col_t col); The corresponding XML is simply: <c:errBars> <c:errBarType val="plus"/> <c:errValType val="cust"/> <c:plus> <c:numRef>...</c:numRef> </c:plus> ...

gitea-mirror added the

feature request

medium term

awaiting user feedback

labels 2026-05-05 11:41:50 -06:00

gitea-mirror commented

2026-05-05 11:41:55 -06:00

Author

Owner

@jmcnamara commented on GitHub (Nov 17, 2017):

The error in science is often different for each measure, so it would be really convenient to be able to define the range of data for the error bars.

For clarity, where is set in the Excel interface. Is this a custom value?

For reference, here is the Python interface which supports custom values: Is that what you are looking for.

@jmcnamara commented on GitHub (Nov 17, 2017): > The error in science is often different for each measure, so it would be really convenient to be able to define the range of data for the error bars. For clarity, where is set in the Excel interface. Is this a custom value? For reference, here is the [Python interface which supports custom value](https://xlsxwriter.readthedocs.io/working_with_charts.html#chart-series-option-error-bars)s: Is that what you are looking for.

gitea-mirror commented

2026-05-05 11:41:57 -06:00

Author

Owner

@Nipou commented on GitHub (Nov 17, 2017):

Yes, see the attachment.

@Nipou commented on GitHub (Nov 17, 2017): Yes, see the attachment.

gitea-mirror commented

2026-05-05 11:41:59 -06:00

Author

Owner

@jmcnamara commented on GitHub (Nov 17, 2017):

@Nipou Attachments are stripped from emails to GitHub. You will have to add it via the web interface. Or else just confirm that you are looking for support of custom values, like the Python API.

@jmcnamara commented on GitHub (Nov 17, 2017): @Nipou Attachments are stripped from emails to GitHub. You will have to add it via the web interface. Or else just confirm that you are looking for support of custom values, like the Python API.

gitea-mirror commented

2026-05-05 11:42:01 -06:00

Author

Owner

@Nipou commented on GitHub (Nov 20, 2017):

Yes, it's custum values like the Python API.

@Nipou commented on GitHub (Nov 20, 2017): Yes, it's custum values like the Python API.

gitea-mirror commented

2026-05-05 11:42:03 -06:00

Author

Owner

@Nipou commented on GitHub (Nov 30, 2017):

@Nipou commented on GitHub (Nov 30, 2017): ![error bars](https://user-images.githubusercontent.com/30089938/33446219-611e9f7c-d5cd-11e7-9f15-a926a066c272.png)