Sparklines are tiny charts of related information covering a range of data placed in an EXCEL cell.
I have Microsoft Office 365 Business version 1704. I will describe using this version of Excel. The data I choose to show is the data related to Opoid related deaths in New York state. I tried to get this data as data from Excel's (Data |From Web) Web menu item in Excel but it was not easy. I just copied and pasted and made some changes. The website for this data is coming
from here:
http://lohud.nydatabases.com/database/opioid-related-deaths-new-york-state
Here is a sample data in a Excel Spreadsheet.
Opoid_00.png
I have the data for all the counties, but the above has only for the top couple of counties.
In Excel you can create the following types of Sparklines:
Opioid_01.png
I will describe how to show the sparklines for the Opoid deaths for say the three counties Albany, Allegany and Bronx.
Highlight the data for the three counties as shown (keep a blank column for the Sparklines). Note that to show with some clarity, the row height has been changed.
Opioid_02.png
Click Sparklines and choose column.
The Sparklines gets into the next column as shown.
Opioid_03.png
Now you can see how the death varied from 2003 to 2014 in the three counties on a comparative basis. Looks like Allegany made the best changes.
I have Microsoft Office 365 Business version 1704. I will describe using this version of Excel. The data I choose to show is the data related to Opoid related deaths in New York state. I tried to get this data as data from Excel's (Data |From Web) Web menu item in Excel but it was not easy. I just copied and pasted and made some changes. The website for this data is coming
from here:
http://lohud.nydatabases.com/database/opioid-related-deaths-new-york-state
Here is a sample data in a Excel Spreadsheet.
Opoid_00.png
I have the data for all the counties, but the above has only for the top couple of counties.
In Excel you can create the following types of Sparklines:
Opioid_01.png
I will describe how to show the sparklines for the Opoid deaths for say the three counties Albany, Allegany and Bronx.
Highlight the data for the three counties as shown (keep a blank column for the Sparklines). Note that to show with some clarity, the row height has been changed.
Opioid_02.png
Click Sparklines and choose column.
The Sparklines gets into the next column as shown.
Opioid_03.png
Now you can see how the death varied from 2003 to 2014 in the three counties on a comparative basis. Looks like Allegany made the best changes.
No comments:
Post a Comment