My favorite on that front is Jon Peltier’s (if you get intrigued by this post, hop over and peruse a slew of other ways to have charts dynamically update).
The single post on this blog that has, for several years now, consistently driven the most traffic to this site, is this one that I wrote almost three years ago.
Apparently, through sheer volume of content on the page and some dumb luck with the post title, I consistently do well for searches for “Excel dynamic named ranges” (long live the long tail of SEO! The kicker is that I wrote that post before I’d discovered the awesomeness of Excel tables, and before Excel 2010 had really gone mainstream.
I’m seeing a lot of referral traffic to this post searching for Excel 2010.
If you’re simply looking for where you define or modify named ranges in Excel 2010 (as one commenter indicated in response to an earlier version of this update), it’s on the Formulas tab in the Defined Names area — Name Manager.
I’ve made a new version of the post that takes advantage of Excel tables, which simplified the process a bit (it’s still kinda’ complicated).
That post is available here.][This post is about dynamic named ranges in Excel 2007.
This blog isn’t really focussed on all of the myriad ways that Excel can be contorted to represent data effectively, but I’m a big believer in using tools as effectively as possible to remove as much rote report generation as possible.
There are lots of blogs devoted entirely to Excel tips and tricks.
Macs are a bit of a crap shoot, unfortunately (but you can always run Parallels, so I hear, and use Excel for Windows! This post describes (and includes a downloadable file of the example) a technique that I’ve used extensively to make short work of updating recurring reports.