Hi. I have a chart that looks at a source data worksheet that is updated monthly.
How do i get my charts to update automatically so that i do not have to edit the source and change the formula everytime?
Thanks in advance
Hi. I have a chart that looks at a source data worksheet that is updated monthly.
How do i get my charts to update automatically so that i do not have to edit the source and change the formula everytime?
Thanks in advance
Last edited by Pickygame; 10-10-2016 at 03:47 PM.
Standard answer is to create a dynamic chart that uses dynamic named ranges. You can put those terms into your favorite search engine and you should find several hits. I will include this one: http://peltiertech.com/Excel/Charts/...umnChart1.html
Originally Posted by shg
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks