Use a throwaway chart to sanity check data

Tip: Use a throwaway chart to sanity check data

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.


Related shortcuts

Leave a Reply

Your email address will not be published. Required fields are marked *