In one of the more consistently popular posts I’ve written, I went into detail about how to set up charts that would update based on a value selected from a couple of dropdown menus – specifically geared towards a dropdown menu that allows the selection of a date such that …
Displaying All Posts Tagged as "dynamic-ranges"
[Update: This post is about dynamic named ranges in Excel 2007. 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 …
Put this down as one of my more tactical posts, brought on by a fit of lingering annoyance with the use (and by “use” I mean “grotesque misuse”) of trend indicators on reports and dashboards. The trouble is that trends are a trickier business than they seem at first blush, …