Charts enable us to identify trends, patterns, and relationships in our data at a glance, however, they can also mislead us. In this video we’re going to look at plotting disparate data in line charts and how they can easily portray the wrong message, and how to ensure you don’t mislead your audience.

0:00 Different ways to chart disparate data
0:21 The problem with line charts
0:59 Log Scales
1:34 Secondary Axis
3:10 Panel Charts
3:39 Indexed Charts
4:10 Calculating the Index
5:31 Summary

#excel #chart #data