Blog Archives
Excel Dynamic Named Ranges Redux — Multiple Series in One Chart March 14, 2011 Excel Tips

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 »

Excel Dynamic Named Ranges = Never Manually Updating Your Charts August 17, 2010 Excel Tips

[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 »

Calculating Trend Indicators October 5, 2009 Presentation

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 »