Hi all,
Can excel automatically up-date a charts source data when new rows of data are added.
For example, I have a chart which reads the current year to the last month end. Every month I add new data and would like the charts to automatically include this. What I do not want is empty rows on the chart.
Thanks.
Without knowing more (like where the data is, how it's updated, how it's stored) it's hard to given a definitive answer but I would certainly suggest you have a look into the possibility of using dynamic named ranges: see http://www.cpearson.com/excel/named.htm for more info and a couple of examples (of which there are plenty on line)
Another link for you -- specifically related to dynamic charting: http://peltiertech.com/Excel/Charts/...umnChart1.html
Be sure to check out Andy Pope's site also: http://www.andypope.info/
Last edited by DonkeyOte; 01-12-2009 at 08:42 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for this. I'll read through.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks