Read Chart Data From Existing Chart Using Python-pptx
I'd like to use the python-pptx library to read data from charts inside a presentation. I've seen the documentation to replace chart data, but I can't figure out how to read data.
Solution 1:
Chart data is:
- the chart's chart-type
- its category names (and possibly hierarchical organization)
- its series names
- and its series values
These are available at the plot level, for example:
>>> chart.chart_type
DOUGHNUT
>>> plot = chart.plots[0]
>>> category_labels = [c.label for c in plot.categories]
["West", "North", "South"]
>>> series = plot.series[0]
>>> series.name
'Sales'
>>> series.values
(17.8, 24.5, 88.0)
There are subtleties depending on the chart/plot type. Consult the API document here to learn more about those. https://python-pptx.readthedocs.io/en/latest/api/chart.html
Post a Comment for "Read Chart Data From Existing Chart Using Python-pptx"