Tag: box plots

  • Visiting a friend

    Chandoo's KPI Dashboards revisited – the Box Plots

    In summer 2008 my friend and Microsoft Excel MVP Chandoo was kind enough to give me the opportunity of contributing guest posts to his excellent blog Chandoo.org. Actually Chandoo even featured a whole 6 post series on how to create interactive KPI dashboards with Microsoft Excel. Here is a screenshot of the final dashboard:

    PHD KPI Dashboard - click to enlarge

     

    The last part of the series was about box plots to visualize the distribution of the data (Box Plots Excel Dashboards Tutorial), including average and target values. At that time Chandoo and I decided to apply Occam’s razor and we restricted the tutorial to a simplified version of box plots, working only for data sets with positive values.

    This follow-up post on my own blog is about how to create these box plots for all kind of data distribution, i.e. positive and negative values.

    (more…)