From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

The three key questions

The three key questions

- [Instructor] The last topic that I want to cover before we dive into Excel is something that I call the three key questions, and these are the questions that you need to ask yourself before you start building or designing or playing with data visualizations to make sure that you're actually on the right track. So first, what type of data are you working with? This has a huge impact in determining which type of visualization you actually use. So whether you have integers, real numbers, categorical data, time-series data, geo-spatial, et cetera. So for instance, categorical data tends to work really well with things like clustered bars or clustered columns, for instance. Time-series data works great with line charts, and obviously, geo-spatial data lends itself very well to maps. Similar kind of question, what are you trying to actually communicate? So what's the point you're getting across? Is it the relationship between variables? Is it a comparison? Are you looking at composition…

Contents