continuing my thoughts from yesterday:Īctually, slope graphs can be quite suitable to show change, e.g. I & rest of our readers are eager to learn from you. How would you visualize such data? Please share your thoughts (or example workbooks) in the comments. Analyzing survey results with panel charts.Since the process of creating this visualization is similar to some of the earlier discussed examples, I recommend you go thru below if you have difficulty understanding this workbook: Conditional formatting to show % change arrows.SUMIFS, INDEX + MATCH formulas for figuring out data. ![]() The key techniques used in this workbook are, Here is a video explaining how the workbook is constructed. Examine the formulas & formatting settings to understand how this is made. Download top 100 cities visualization – Excel workbookĬlick here to download this workbook. This chart (well, a glorified table) not only allows for understanding all the data, but also lets you focus specific groups of cities (top % changes, new cities in the top 100, cities that dropped out etc.) with ease. Here is a chart I prepared from this data. I downloaded my website visitor city data for top 100 cities in September 2014 & September 2013 from Google Analytics.Īnd I could get it for exactly $0.00. So armed with the certainty that my kidney will stay with me, I now turned my attention to a similar data set. May be if they had sparklines in the file… Turns out, Economist sells this data for a meager price of US $5,625.Īlas, I was saving my left kidney for something more prominent than a bunch of raw data in a workbook. So I went looking for the raw data behind this graphical mess. Creating a better chart from this data, now thats awesome. Some points have no labels (or ambiguous labels) leading to further confusion.Īfter examining the chart long & hard, I got thinking. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |