Saturday, 14 January 2012

Florence Nightingale Circumplex Chart

I was taken to Florence Nightingale's Wiki page during a recent research, and one of the interesting things I noted was her contribution to statistics. It came to me as a pleasant surprise that she is credited with inventing the polar area diagram, or occasionally the Nightingale rose diagram, which is equivalent to a modern circular histogram.

Following the completion of my project and in my weekend to spare, I devoted time to recreating the chart in Excel. It took a combination of Doughnut-Pie-and XY charts and close to four hours to finish it. The colors are a bit darker, the values are approximate and the labels differently oriented, yet the chart looks fairly close to the original as is shown by the picture below.

1 comment:

  1. could you please provide a copy of the excel file? I tried to download it, but it's password protected. or, if not, could you please privde a tutorial of some sorts to get an idea of how to create this graph in Excel.
    I would do it in CorelDraw or Illustrator, but that'd be cheating, as I really want to create it dynamically in Excel?