• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Andy Holaday

  1. A

    Where has Application.OnKey Been All My Life?

    Being the steadfast keyboard user that I am, I have been silently lamenting for years that Excel 2003 does not offer a robust way to create keyboard shortcuts. True, you can assign a macro to fire with Ctrl + {key of your choice} but most of the choices are already associated with useful Excel...
  2. A

    Next Big Sound - Beautiful Line Charts to Understand Music Popularity

    Not a bad presentation, except for the wandering y-axis range that tends to misrepresent the significance of the results. The interactive search is nice. I wonder what's going on with the data. Most spikes of "interest" seem to occur on a Tuesday. Given the named sources (MySpace, lastfm...
  3. A

    How we spend our time [interactive visualization on nytimes]

    This is a great way to show the contributions to a whole in a time series. I made a similar, static graph for the business that was well received. The interactive feature in the NYT version is neat, something I might try out in Excel.
  4. A

    Excel Dashboard Competition at Bonavista Systems

    Contenders take heart -- the expiry date published in the link has apparently been revised/extended. See http://www.bonavistasystems.com/NewsMicroChartsCompetition2009.html
  5. A

    Generate a unique list from a large set of data

    Seems like you could use a pivot table? Based on your sample you might need to massage the source data a little (e.g., to map "Travel 2" to "Travel") but otherwise a PT seems like the tool made for the job.
  6. A

    Hello .. Introduce yourself

    Hi, Andy here. I stumbled in to Chandoo's spot a year ago and have been a fan ever since. I do analysis and provide data support for the Actuarial department at a private insurance firm. I love to learn and help out where I can, especially with Excel formulas, VBA, work flows and data visualization.