Title: How to set dynamic chart range in excelwriter
Tags: python;pandas.excelwriter
Question: Hello we receive this data set monthly and it will add another row to the data set on a monthly basis. We create a chart from the data series, however I have to manually select the rows each month that this data set comes out. Is there an easy way to change the below in order to make the categories and values selection dynamic based on the available data?
chart1b.add_series({'name' : 'm/m (%) change', categories' : '=Insta_Followers_TimeSeries!$A$2:$A$57','values' : '=Insta_Followers_TimeSeries!$D$2:$D$57','y2_axis': True, 'line': {'color':'#4D3C2F'},})
Looking to change $A$2:$A$57 for example and every month it increases by 1 or more depending on available data. Same with $D$2:$D$57. Thank you



{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 0, 'ContentLicense': 'CC BY-SA 4.0', 'CreationDate': '2022:00:05/26/22', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<python><pandas.excelwriter>', 'Title': 'How to set dynamic chart range in excelwriter', 'ViewCount': 21, 'id': 72390031, 'user_AboutMe': '', 'user_AccountId': 24911736.0, 'user_DisplayName': 'Paul', 'user_Reputation': 47.0, 'user_Views': 4.0, 'user_id': 18781205.0}}