Charts for ordering and ranking data points
If you want to make a choropleth/thematic map in Excel without programming perhaps conditional formatting is all you need. Here is how to do it: Select a few hundred columns and rows; Set width and height to 3 (more or less, depending on the resolutions you want); Set font size to 1; Place a map … Read more
Human creativity is virtually limitless. But: You don’t vary color by data point. You don’t force the eyes to a pendular movement if you can avoid it. You don’t use a legend when you can use axis labels. You can’t have a residual category that large. Bloggers don’t seem to learn, even with a good teacher. … Read more
These are 10 basic tips for column and bar chart design: A column chart is not a skyline: if you can’t see the individual patterns, consider removing some series or create several smaller charts; If you are charting categorical data sort the columns; if there is more than one series, allow the user to sort … Read more
How do you create a thematic map like the one above for your next presentation if you don’t have a mapping tool? Simple, create it in Excel. Easier said than done, right? Well, not really… You know that you can add shapes to your worksheet, don’t you? So, why not to add shapes that mirror … Read more
This chart [fusion_builder_container hundred_percent=”yes” overflow=”visible”][fusion_builder_row][fusion_builder_column type=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”no” center_content=”no” min_height=”none”][via Junk Charts] in the New York Times uses a “tornado” chart (a population pyramid-like chart) to display two series, advertising spending in measured (traditional media) and unmeasured (Internet…) channels. … Read more
Screencast: How to create a population pyramid in Excel. I am a big fan of screencasts, as a regular reader of this blog may have already noticed. They are great at showing how to use a tool to get something done and they are the best companions for tutorial (e-)books. This hypotetical regular reader might … Read more