Excel Dashboard Color Scheme Selector

I recently stumbled upon Josh Tapley’s nifty Color Picker for Xcelsius dashboards. In his post, Josh says:

“Many times I have seen themes that I like on Adobe’s Kuler and ColourLovers.com only to find out that they don’t translate well to graph format.”

I completely agree! Being one who’s more than willing to steal brilliant ideas, I thought I’d try replicating Josh’s color picker in Excel.

I created an Excel workbook that allows you to

cycle through a set of color schemes to find one that suits your dashboard. Once you have one you like, simply note the RGB values in cells M2:M6, or click the Capture Colors button to have the colors added to your Recently Used Colors panel.

ColorScheme

I even added a table where you can edit the color schemes with stolen your own HEX color combinations.

I’m sure there is a way to programmatically create a new theme based on the chosen colors, but I’m too lazy to figure that out right now.

I left all the code in the workbook open for your reading pleasure.

Feel free to download the Color Scheme Selector workbook.

Happy coloring!

5 thoughts on “Excel Dashboard Color Scheme Selector

Leave a Reply

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