automatically expand chart data series as data is added
I have several time series charts thta I update for each business day. I
would like the chart data series's to automaticallt expand as I add data. |
automatically expand chart data series as data is added
Hi,
You need to read up on dynamic named ranges. http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm Cheers Andy jlarson wrote: I have several time series charts thta I update for each business day. I would like the chart data series's to automaticallt expand as I add data. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 01:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com