fbpx
Search
Close this search box.

What are your favorite colors for charts?

Share

Facebook
Twitter
LinkedIn

Ok, it is Friday again. That means poll time. I would like to know what color choices you prefer for your charts?

My Favorite Colors for Charting

These are the colors I use when making charts in Excel 2007.

chart color choices - my favorites

Here is a file with all these colors, so that you can copy them to your charts right-away.

Also, these are the colors I recommend in an e-book (you get a copy of that free with Project Management Templates) for people making charts:

Chart Color Choices - Recommended

What about you?

Share your favorite colors thru comments.

Just list down the RGB codes of your color choices.

More Resources on Charting & Colors:

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

20 Responses to “What are your favorite colors for charts?”

  1. Paresh Shah says:

    An excellent reference on the use of color in charts by Stephen Few is available here: http://www.perceptualedge.com/articles/visual_business_intelligence/rules_for_using_color.pdf

    The concepts and the rationale are beautifully explained.

  2. Vasily says:

    Good job and perfect startpoint for improvements 😉
    1. It's not good that your colours are not supported by Excel 2003
    2. Also i'm always trying to make charts look sexy both in colours (for display) and gray-scale (for printing).

    Personnaly I use
    ACT vs BUD: ??
    Win/Loss marks: ? ?

    And also I like to highlight variance columns in tables with ?

  3. Vasily says:

    hm... never been HTML Pro :-(. Will do it as usual 😉
    ACT vs BUD: #3366FF, #FFCC00
    Win/Loss: #339966, #FF0000
    Variance highlight: #FFFF99

    Regards, Vasily

  4. Chandoo says:

    Test comment -

  5. Vasily says:

    ACTV vs BUD: █ █
    Win/Loss: █ █
    Variance highlight: █

  6. Jennifer says:

    I work with data related to student learning and rarely deviate from the following colors:

    ?
    ?
    ?
    ?

  7. Jennifer says:

    Well - that's embarrassing. Not only did I doublepost, my code didn't work. My colors are not especially creative - just red, yellow, dark green, and bright green (corresponding to the four common levels used to describe student performance).

  8. Chandoo says:

    Well, looks like a lot of you are having problems with HTML code. Just list down your favorite RGBs instead. I know it is kind of lame. But I will make it up to you by making a nice chart of all the favorite RGBs...

  9. for our printed books we use
    #33E6D9
    #FFA600
    #A64B00
    #8CCCF2
    #ED0000
    #A6FF00
    #8C19A3
    #00AAE6
    #5CF22C
    #FF6600
    #806600
    #0057D9
    i.e. http://www.oecd.org/publications/factbook
    the idea is that these are very saturated colours. remember, these are for books, right? and books are separated into chapters or parts. So for the 1st chapter, we'd use the 1st color, #33E6D9 (it's a blue). If we need a secondary colour in a chart, if it's to highlight a data point we'd take the next colour in the cycle (#FFA600, a golden orange). But if it's to show a secondary colour we'd just use a less saturated & darker version of the 1st colour. And then, for the next chapter, we'd do the same, but basing ourselves on the #FFA600 colour, etc, etc.

  10. Ninad Pradhan says:

    When in doubt - ASK. And that's what I did. GIYF..........http://colorbrewer2.org/

    Regards,

    Ninad.

  11. Ninad Pradhan says:

    http://colorbrewer2.org/ Sorry the link above didn't show up properly.

    @Chandoo: is it possible to add an EDIT feature to the posts, this way double posts can be avoided for the same message.

    • Chandoo says:

      @Ninad ... Thanks for the colorbrewer link. Good one.

      Btw, I cannot add EDIT option as it would take too much tweaking of the fragile code in commenting system. I am hoping to get a theme upgrade in the coming months which should provide very good commenting experience.

  12. Bill says:

    I too am a colorbrewer user. I always use 4-class sequential OrRd or a subset thereof. It's the only 4 colour combination that passes the print b/w, projector and colour blind requirement.
    Jennifer: Your choice above ranging from red to bright green is not colour blind friendly! It's a common choice, but common doesn't make it good.

  13. Matt Healy says:

    I agree with the recommendation of Color Brewer, it's an excellent site. Its creator, Cynthia A. Brewer, is an associate professor of cartography at Penn State who has done consulting work on map color schemes for various US government agencies.

  14. Rwth says:

    Interesting post and some good tips for colour guidance.

    Small, unrelated question; on the example 'Chart Colors' spreadsheet, how do you lock the unused, grey area of the worksheet so that no cells from the blank portion of the worksheet can be selected?

  15. [...] Use colors that connect: This chart uses bright yellow color, almost the same as the skin color of Simpson’s characters. It connects well with the audience. You should try to use colors that evoke emotional responses from your audience, whenever possible.(tip: using color in charts) [...]

  16. Aisha says:

    Hi,

    Okay, I have this not-so-common type of a question. I have been using excel to analyze the data I have got from a biology experiment. I have to represent one set of data in a circular chart format (since the chromosome is circular). I need to show alternate data points in the same colour and there are a total of 142 data points. I did it once and had to spend a lot of time doing it manually since I could not find it in excel to do it quickly. Do you know a shortcut such that I can represent the data in just two colours (actually no colour and colour) alternating with each other? I can send you an example file of my previous chart and data if you need an idea.
    Thanks!!
    Aisha.

Leave a Reply