Auto increment chart range montly
I have a number of situations where I add a row of data each month and then
have to change all the series definitions of all the related charts. Is there an easy way to automate this? |
Auto increment chart range montly
Hi,
You can used named ranges to auto expand chart data. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy comfuted wrote: I have a number of situations where I add a row of data each month and then have to change all the series definitions of all the related charts. Is there an easy way to automate this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com