Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

A way to exclude excel columns in the series. #1043

Open
evanwalter opened this issue Jan 31, 2025 · 2 comments
Open

A way to exclude excel columns in the series. #1043

evanwalter opened this issue Jan 31, 2025 · 2 comments

Comments

@evanwalter
Copy link

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.

@mszbot
Copy link

mszbot commented Feb 17, 2025

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.

@MartinPacker
Copy link

A couple of potential approaches - but neither is directly in python-pptx:

  1. Create a temporary sheet from the permanent.
  2. Extract the data from the permanent sheet and drive python-pptx charting directly.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants