#🔒 Cant alter Excel chart titles/axis with Python script

7 messages · Page 1 of 1 (latest)

echo kraken
#

Hello,
I have plenty of Excel workbooks with multiple sheets (+150 sheets in total). These sheets contains figures (charts) where I need to adjust the y-axis title as well as change the x-axis limit. My current code opens the Excel books and iterates through every sheet but comes across some kind of error (?). I will link my code in a pastebin.

Hope anyone can help, thanks in advance!! 🙂

hollow zephyrBOT
#

@echo kraken

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
echo kraken
#

This is the type of error that I receive:
General error updating chart in sheet Sheet1 of test.xlsx: (-2147352570, 'Unknown name.', None, None)

echo kraken
#

Anyone have any ideas?

hollow zephyrBOT
#

@echo kraken

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.