fbpx

Format charts quickly with chart styles & color themes [quick tip]

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Here is a quick tip to reduce the time you spend on chart formatting – use chart styles & color themes.

Excel offers various pre-defined color schemes and chart styles. Using them is very simple.

  1. Select your chart
  2. Go to Chart Design ribbon
  3. Click on the style or color scheme you want.
  4. Your chart changes instantly.

Check out below screencast to learn more.

change-colors-and-design-of-charts-demo

Using predefined styles is a great way to polish your chart. Keep in mind that not all predefined styles look gorgeous. So choose wisely.

Do you use chart styles?

I use chart styles or templates to speed up chart formatting.

What about you? Do you use these features? Share your experience in the comments section.

More chart formatting tips:

 

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
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

Chandoo is an awesome teacher
5/5

– Jason

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

100 Excel Formulas List

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

20 Excel Templates

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

IRR and data tables in Excel

Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

  • Introduction to IRR & XIRR functions
  • Calculate rate of return from a set of cash-flows with XIRR
  • Simulating purchase or terminal value changes with data tables
  • Apply conditional formatting to visualize the outputs
  • Common issues and challenges faced when using XIRR

4 Responses to “Format charts quickly with chart styles & color themes [quick tip]”

  1. Heather says:

    If I'm in a hurry for formatting, then I start from one of the predefined formats, and then change the elements that I don't like.

    But if I'm building a dashboard, I generally design all charts based off of my own design so that I have the company colors, etc.

  2. A.Maurizio says:

    Good morning my name is John, I am writing because I would like to know how to fix this problem. Using a Chart I created an analog clock, Now my problem is this: I want to figure out how to color with red dots that symbolize the end of minutes (Five; Ten; Fifteen) etc. ...! Let me explain: In this Chart I entered a series of codes of (Radians) to symbolize the minutes and hours. For here that said, I wish every time the chronograph minute match the cue ball for example: of the 15 minutes, the cue ball is he colored red; All this as you do; Thanks in advance for any help you offer me on, sincere greetings from a. Maurizio

  3. Excel Whizz says:

    Nice tip Chandoo this can save a lot of time, I also find the recommended charts feature (Excel 2013>) great for quickly putting something visual together.

    Does anyone have a solution for creating the illusion of conditional formatting on charts i.e. red when under target, green when above?

Leave a Reply