Log in to like this post! How to choose the best chart for your data Casey McGuigan / Wednesday, March 14, 2018 The amount of data at our fingers tips today can be overwhelming. How do you know what really matters? Data visualizations can help, but how can you set up your data to best visualize it? What chart will help you analyze and digest the data into actionable insights? One struggle is that there are so many different chart types. How do know which one is going to bring the most meaning to your data? Are you measuring performance? Do you have 1 or many variables? Is your data time-based? Geospatial? How many data points do you have? Are you comparing different categories of data? Kinds of Charts There are 7 different types of relationships that charts are typically used to display: Nominal comparison: Display a series of discrete quantitative values so they can be easily seen and compared Time Series: Shows quantitative values that are associated with categorical subdivisions of time. Will help you to view trends over time in a sequential, chronological order Ranking: Shows individual quantitative values associated with a set of categorical subdivisions relate to each other sequentially by size. Data is displayed from Highest to Lowest or Lowest to Highest Part to Whole: Shows individual quantitative values associated with a set of categorical subdivisions related to the complete set of values (and each other). The common unit of measurement is a percentage. Deviation: Relationship of one or more sets of quantitative values differ from a primary set of values. The units of measure are actual units, ratio relative to primary value, positive or negative Ratios Distribution: Shows how a set of quantitative values are distributed across its entire range, from lowest to highest. Correlation: Display whether two paired sets of quantitative values vary in relation to each other. The correlation will show the direction and the degree, High or Low, Positive or Negative Choosing Your Chart When choosing a chart type is it best to keep 4 communication methods in mind. 1. Do you want to communicate a composition of your data? A composition chart is designed to show different parts of information that make up a whole. Such as your total sales broken down by product line or sales rep. Charts that best communicate a composition are: Stacked Column / Bar: Changing over time, Few Periods, Relative & Absolute differences matter Stacked 100% Column / Bar: Changing over time, Few Periods, Only Relative Differences Matter Stacked Area: Changing over time, Many periods, Relative & Absolute differences matter 100% Stacked Area: Changing over time, Many periods, Only Relative Differences Matter Pie: Static, Simply show the share of a total Waterfall: Static, Accumulation or Subtraction to total 2. Do you want to communicate a relationship between two data sets? A relationship will show a correlation between two or more variables through the data you pull together. This can be used to show either a positive or a negative effect that the given variables have on each other. Charts that best communicate a relationship are: Scatter: Two variables Bubble: Three or more variables Line: Two variables 3. Do you want to communicate the distribution of your data? A distribution chart is used to show the behavior of certain variable over time to help identify any outliers, normal tendencies, and a range of your information and trends. Charts that best communicate a distribution are: Scatter: Two variables Line: Single variable, Many data points Column: Single variable, Few data points Bar: Single Variable, Few data points 4. Do you want to communicate compare different variables of your data? A comparison chart is used for comparing one or more sets of data where you can easily show the minimum and maximum values of that set. This chart tried to fix each set of variables from the others and display how those variables compare. For example: Column: Among items, One variable per item, few categories, many items Column: Among items, One variable per item, few categories, few items Column: Over time, Few Periods, Single or few categories Circular Area: Over Time, Many periods, Cyclical Data Line: Over time, Many periods, Non-Cyclical Data Line: Over time, Few periods, Many categories To try all of these charts, download a free trial of ReportPlus today!