Caution: Visual Interpretation Error in Data Analytics

We have seen how to put data bars in Excel (Bar charts with a difference). These help us compare any value with any other value visually. This helps us understand patterns in the data.

image

If not used properly, this great feature can lead to confusion and misinterpretation as well. Here are common scenarios and the solutions.

Different Column Widths

It is obvious that for proper interpretation, all columns should have the same width. However, if you have multiple columns, some widths may not be same and you may not notice it. Worse still, you may change column widths for some other data in the same column and may not realize its effect on the Data bars.

image

Pivot Tables in Compact Mode

This problem occurs naturally with Pivot Tables.

image

The solution is to adjust the width manually or change the layout to Tabular Mode (Design Tab – Report Layout)

Different Row Height

This can happen due to text wrapping in one or more cells. This also disturbs the proportions and leads to confusion. Keep the height exactly same for all rows.

image

Key Learning

Visual interpretation is prone to distortion. The flexibility which Excel offers can hamper the accurate interpretation of data if you are not careful.

***

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s