python-pptx
python-pptx copied to clipboard
A way to exclude excel columns in the series.
I would like to generate a chart whose series are a subset of the excel data behind it. All the data would be available in the excel data behind the chart, but the chart would not show all the columns.
Not possible in this library. Python-pptx overwrites the entire spreadsheet behind a chart. You cannot target a specific cell range or hide and show specific columns. You can sponsor this development by messaging the Author directly.
A couple of potential approaches - but neither is directly in python-pptx:
- Create a temporary sheet from the permanent.
- Extract the data from the permanent sheet and drive python-pptx charting directly.