Lost in colors

Which one of the following charts use better colors?

Excel Tip - Lost in Color 1.PNG

It is not surprising if you prefer the one on the left as the colors used are of high contrast.

However, will you change your mind after you read the same charts printed in black and white?

Excel Tip - Lost in Color 2.PNG

You can see from the above, the original contrasting colors on the left become hard to distinguish from each other at a glance.  (Believe it or not, if the quality of your printer is not so good, the colors may look the same…)

On the contrary, the colors used in the other chart still stand out from each other.


Let’s take a look at the color plates:Excel Tip - Lost in Color3.PNG

When we read across on a row, we see that some colors look almost the same when printed in black and white.  e.g. The Red (2nd column) and Purple (last column) of the standard colors

However, when we read down on a column (i.e. same color of different intensity), we can still easily see the difference.  Right!?

So now, which one do you prefer?Excel Tip - Lost in Color 1.PNG

Think about how your audience is going to read your report.  @_@


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, General. Bookmark the permalink.

Comments, suggestions, corrections are welcome.

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.