In this video, we’ll look at how to use a throwaway chart to explore data.
In most cases, you’ll want to take time to build clean, uncluttered charts that are easy to read.
However, a quick disposable chart is a great way to check and explore data.
For example, in this worksheet, I have some sample sales data from a Microsoft tutorial on pivot tables. I don’t really know much about this data, but I can learn a lot quickly with a chart.
I’ll start by selecting all of the amounts, and use the keyboard shortcut Alt + F1 to build a chart.