Blog Archives
Excel Dynamic Named Ranges Redux — Multiple Series in One Chart
March 14, 2011
Excel Tips
Excel Dynamic Named Ranges = Never Manually Updating Your Charts
August 17, 2010
Excel Tips
Calculating Trend Indicators
October 5, 2009
Presentation
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 ...... Continue »
[This post was written in 2010. 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). ...... Continue »
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 ...... Continue »