[GH-ISSUE #160] Feature Request: Chart Sizing options #130

New issue

Closed

opened 2026-05-05 11:45:01 -06:00 by gitea-mirror · 1 comment

gitea-mirror commented

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

Owner

Originally created by @TitanicHispanic on GitHub (Apr 5, 2018).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/160

Originally assigned to: @jmcnamara on GitHub.

While using scale does indeed work, it is a rather abstract way to measure or set a chart's dimensions.

With that in mind, I'm requesting the added options of chart_w & chart_h to lxw_image_options, or the introduction of lxw_chart_options with chart configuration options.

Other, slower libraries do offer options, ranging from cellTo & cellFrom or x/y pairs. libxlsxwriter outperforms the other libraries I evaluated, so I'm hopeful this can happen.

Originally created by @TitanicHispanic on GitHub (Apr 5, 2018). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/160 Originally assigned to: @jmcnamara on GitHub. While using **scale** does indeed work, it is a rather abstract way to measure or set a chart's dimensions. With that in mind, I'm requesting the added options of **chart_w** & **chart_h** to **lxw_image_options**, or the introduction of **lxw_chart_options** with chart configuration options. Other, slower libraries do offer options, ranging from cellTo & cellFrom or x/y pairs. **libxlsxwriter** outperforms the other libraries I evaluated, so I'm hopeful this can happen.

gitea-mirror

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

closed this issue
added the
feature request

wontfix
labels

gitea-mirror commented

2026-05-05 11:45:05 -06:00

Author

Owner

@jmcnamara commented on GitHub (Apr 5, 2018):

I'm hopeful this can happen.

It won't happen.

Libxlsxwriter is a port of XlsxWriter and Excel::Writer::XLSX all of which have the same interface.

Chart sizes in Excel are a fixed size in pixels, row heights and column widths are fixed sizes in pixels (unless the user changes them). So it is possible for an end-user application to calculate the required scale to get a chart to span a user-defined number of cells, without support from the library.

@jmcnamara commented on GitHub (Apr 5, 2018): > I'm hopeful this can happen. It won't happen. Libxlsxwriter is a port of [XlsxWriter](https://github.com/jmcnamara/XlsxWriter) and [Excel::Writer::XLSX](https://github.com/jmcnamara/excel-writer-xlsx) all of which have the same interface. Chart sizes in Excel are a fixed size in pixels, row heights and column widths are fixed sizes in pixels (unless the user changes them). So it is possible for an end-user application to calculate the required scale to get a chart to span a user-defined number of cells, without support from the library.

gitea-mirror referenced this issue

2026-05-05 12:15:30 -06:00

[PR #130] [MERGED] Patch to install DLL to bind dir #423