## Data Visualization for Excel Users – How to Make a Chart, Part I: Asking Questions

A new page is available in my tutorial “Data visualization for Excel Users”. It’s the first page of a mini series on how to make a chart and we’ll learn how to ask questions and what type of questions we should ask.

We are so busy creating sexy charts to illustrate some random data that we often forget to check if our chart really answers the question. Heck, most of the times we don’t even have one. Chart first, ask questions later. One of the major differences between tables and charts is this: a tables says “here … Read more

## Chart-Making: Cures for Loss Aversion

Loss aversion – wrong chart example JunkCharts writes an interesting post on how loss aversion can happen in chart-making. The general concept of loss aversion tells us that “people strongly prefer avoiding losses than acquiring gains”. Translated to chart-making, it means that there is a “tendency to avoid losing data at any cost”. “To clarify, … Read more

## You want answers, but do you have questions?

A chart is always an answer to an underlying question. If you don’t know the question be prepared for random answers (300-slide Powerpoint presentations, anyone?). Do yourself a favor and and write down the questions that define your project. Group them meaningfully and use them as chart titles. Each chart may prove irrelevant or force … Read more

## Charting tips 002: Consider the task at hand

Suppose you are sharing a list of orders with some co-workers. One of them wants to see the higher sales orders [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”][list]. Another one wants to know how much was exported to … Read more