Data Visualization in Microsoft Excel

ByHariharan Rajendran

Data Visualization in Microsoft Excel

Data is the most valuable asset in almost all the places.

Understanding the data is not easy for a layman. Visualization tools are playing a vital role to make the layman to understand about the data. Most of business decisions based on best data visualization.

This article speaks about simple visuals based on data about cancer statistics.

Just collected a few facts about the estimated number of new cancer cases in US 2015.

Ref: http://www.cancer.org/acs/groups/content/@editorial/documents/document/acspc-044552.pdf

DataVisual1

 

Visualization tools always helping us to see the facts very clearly. I just converted the data to graphs by using simple and effective Microsoft Excel.

Estimated New Cases for Both Male and Female:

DataVisual2

Estimated New cases for Male Vs Female:

DataVisual3

This is just to help you understand the facts about cancer diseases.

Learning Steps:

  1. Get the data from above reference link, copy and paste the data in Microsoft Excel sheet (it can be any version).
  2. Select the columns and rows and click the “Format as Table” ( Option available in Home tab & Styles section)
  3. If you want to see the chart for sites with Male, just hide the both sexes and Female columns by clicking right click on column B and D.
  4. Select the data from cell A1 to C16
  5. Go to insert tab which is next to Home on top and click the pie chart on chart section.
  6. Pie chart appeared for selected data. Try to check with other chart formats.

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a Microsoft Certified Trainer with 9+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Comments Are Closed!!!