However, a quick disposable chart is a great way to check and explore data.
The result is a messy column chart, but there’s a lot of good information here.
First, I can see there are over 700 transactions total.
Without category labels to work with, the horizontal axis is simply a count of values or rows.
Looking at the vertical axis, I can see that most transactions are $500 or lower.
The largest transactions are between $2,000 and $2,500.
I can hover over any column to see the exact value.
And, I know all this in less than a minute.
What else can we see?
Well, looking more closely at the bars, I can guess that this probably isn’t real data.
I say this because I can see distinct clustering at certain levels.
Now, let me delete the chart, and introduce a big data entry error.
On a random line, I’ll add an extra digit to a unit price.
Now I’ll chart the data again.
This time, the chart clearly shows the outlier.
Even if I know nothing about the data, I can guess this is a mistake.
So, the next time you gotta quickly understand unfamiliar data, try a disposable chart.
For more details, see the section on Pivot Charts.
