From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Unlock this course with a free trial
Join today to access over 24,200 courses taught by industry experts.
The three key questions - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.