Skip to main content

US Cancer Stats 2010

I do habitually trawl a lot of websites. Partly because of my interests, partly due to my commitments, and some because I'm concerned. One among the last is The American Cancer Society Inc. A comprehensive website that incorporates A-Z of cancer. From learning about the disease to its treatment and from all relevant data to a chance to volunteer and make a difference, it includes all. The data is from the section Cancer Facts and Figures 2010. I know a similar page exists for the year 2011, but I'd rather wait for the year to be over and the numbers updated, so I can then not only look at the data, but also perform a meaningful comparison against the previous year.

The dataset is taken from page 3 of the PDF file, titled "Estimated new cancer cases and deaths by sex for all sites, US, 2010". Sadly, there can be no correlation between new cases and deaths, so, my main focus was to find the best way possible to represent this data in a dashboard. To make this more challenging, I desisted from using macros, and decided to use Pie-charts!

To keep the dashboard simple, I've used a pair of List Boxes, and the type selected in one will populate the related sub-types in the second.

After about 30 minutes of playing with the data, the dashboard came out as below:

Comments

Popular posts from this blog

The Playfair Charts: Scotland ExIm Barchart

Soon after finishing the second Playfair chart, the one on Wheat Price and Wages, I searched the internet for additional charts made by him. I found a Bar chart circa 1786, which showed the Scottish export and import volumes with other countries. For me, the real thrill was to scroll by the list of the name of places long consigned to history books - Jersey Is, Greenland, Prussia, Denmark and Norway (together) and Flanders.  First, the original Playfair Barchart from Wikipedia,  Then, my version of it in Excel.  A couple of parting words:  Excel 2007 no longer support dots and lines as fillers for charts. Hence, the ribbed import chart is given a different color, Gold.  Normally, I'd use data point labels to construct the chart legends and other declarations given at the bottom of the chart. However, given Excel 2007' inability to automatically re-size labels to fit texts, I was forced to use text-boxes instead. 

The Dorling Cartogram

My last project involved using a multitude of regions for drawing analysis, parallels and comparison. Not wanting to use yet another Choropleth graph, I decided to look up alternatives that were easier to create and preferably required no VBA. Soon I stumbled upon "The Dorling Cartogram", defined in the UCSB site as, "This type of cartogram was named after its inventor, Danny Dorling of the University of Leeds. A Dorling cartogram maintains neither shape, topology nor object centroids, though it has proven to be a very effective cartogram method. To create a Dorling cartogram, instead of enlarging or shrinking the objects themselves, the cartographer will replace the objects with a uniform shape, usually a circle, of the appropriate size." I had the data for Obesity in the United States handy, so I decided to give it a try before using it in my project. I opted to use Bubble charts because data points within a series may need to be of varied shapes based on...

The Pie-Doughnut Combination: A Fan Plot

Happy to be back after a pretty busy beginning to the new year. I had this completed almost immediately following the preceding post but was otherwise hard-pressed to find a suitable time to post it. Soon after writing the Florence Nightingale Circumplex Chart post, I started searching for more varieties of charts that can be created using combinations of Pie-Doughnut charts. Soon enough, I found one through Naomi B. Robbins' comment in a Jorge Camoes' post . The referenced PDF article attempts to use Fan Plot to display relative quantities and differences using the R statistical language as is shown in the image below. Impassive of its benefits and/or disadvantages, I created it in Excel.