Spruce up you Color Palette in Excel – ColorBrewer – Excel Design Tips

Tired of the same old color palette in Excel?

You know what I mean. Its either Excel Green, Word Blue or Powerpoint Purple. Maybe a few different hues of each color.

But if you are a “designer”, it leaves something to be desired. No self respecting Excel Dashboard designer is showing up with an out of the box palette.

So what do you do?

How do you make the Boss think you know what to do?

Jordan suggests heading over to ColorBrewer2.org  Jordan initially picked up this tip from Stephen Few.  Stephen is one of the Dashboarding design gurus, his book Information Dashboard Design.

2015-02-23_18-38-20

Give your newest Excel design some pizzaz with these steps.

bullet step 1

Head over to ColorBrewer2.org

This has to be the easiest step.  Just click the link

This helps you create a color scheme for your categorical or ordinal data.  What’s that?  Categories or ordered data…  you know data that is ordered, like first second, third.  Huge, kinda big, small.

bullet step 2Play around

Select the number of classes and a hue that you like.  Perhaps something that is aligned with your corporate colors.

2015-02-23_18-50-01

 2014-10-28_17-20-23Insert the RGB Code into Excel

First off select RGB from the dropdown box is ColorBrewer.  Excel likes RGB, so use it.

In Excel, from your home menu (where all the formatting is) select that paint bucket…  or fill color… or whatever.

Select More Colors

Input the RGB codes.

These now show up in your recent colors.

Check out Jordan’s Book

Advanced Excel Essentials will question the way you attack your Excel problems.  Check it out.


Tags


You may also like

December 20, 2013

100+ Best Excel Resources And Websites

August 6, 2019

How to Create a Relative File Path in Power Query

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

September 17, 2012

The Excel Rollover Mini FAQ

February 17, 2014

It’s time to say “Goodbye,” to Hungarian Notation
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

>