You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
This post is brought to you by Alex Mullans, a Program Manager on the Office Graphics & Visualizations team.
Charts are a method for visual storytelling. You may not judge a story by its cover, but a great cover (or chart) will absolutely draw in more readers to engage with the rest of your content. So, we've built lots of options into Office charts to help you craft a visually appealing chart. There's an option for everyone and (we hope) every scenario, no matter how much or little customization you'd like to do.
Themes and Chart Colors are great choices for quick-and-easy customization: just a couple clicks and you're done. Likewise, Chart Styles can give your chart a whole new look with just one click. And, when those options don't have what you're looking for - or you just want to take matters into your own hands - the charts Task Pane has tons of options just waiting to be explored. You can create great charts using any of these methods; in this article, I'll use a little of all of them.
I'm writing this post from a flight that was delayed, so the story I'd like to tell is about the best flight choices from Detroit to Seattle, based on average delays, maximum delays, and historical on-time performance. To do that, I created the combo chart below. To comply with chart best practices, I made the following changes to the default chart I got from the Recommended Charts screen (see this post for more details about Recommended Charts and Combo Charts):
As it stands, this is a perfectly workable chart. It's clean and readable, and it conveys a good amount of information. But it's not quite the chart I'm looking for.
Specifically, that orange is a bit bright for my taste. To change it:
With just a few clicks, I've toned it down a bit. Note that this button only affected the chart I selected; the colors in the rest of my workbook are just as they were before.
Now, if none of the colors in the Change Colors button catches your eye, changing your Excel workbook's theme will give you even more color choices. To do so:
Do keep in mind that changing the Theme Colors affects your entire workbook (including other charts and theme-dependent objects like SmartArt).
Chart Styles are a great way to go a little beyond just changing the colors of your chart - they affect more of your chart than the Chart Colors button does, but they're still one-click easy. One of my favorites is the dark style, especially if you're going to use your chart in a PowerPoint presentation with a dark background. To apply a Chart Style:
Something to remember: Chart Colors and Theme Colors both impact Chart Styles - each Chart Style will change based on your selected Theme and Color set.
It's entirely possible never to use the Task Pane. For some charts, Chart Colors, Theme Colors, and Chart Styles will take care of the stylistic changes needed. But for charts that need more customization, the Task Pane is the place to look.
You might have noticed that the dark chart in the previous section had several changes: the lines became thicker, they acquired shadows, and the background became a radial black/grey gradient. Those changes are just some of the customizations that you can make in the Task Pane. Anything from the pattern of your lines and bars (e.g., dashed or shaded) to the content of your data labels can be changed in the Task Pane.
To open the Task Pane, just double-click on any chart element such as a series or the title. In this case, I double-clicked on the blue Max Delay line.
You also can choose an element and open the Task Pane from the Ribbon. To do so:
To start out, I'm going to change the color of my max delay series. Visually, this adds contrast and highlights the series. In addition, changing the color adds a semantic meaning - delays in the US are generally shown in red--that helps my chart tell its story. To do that, I can:
Next, I'd like to call out that high point on the Max Delay series, because the potential for almost 500 minutes of delay is something I'd like to avoid! To do so, I:
There's a bit more information in the callouts than I need. I'd like to remove the flight number, because that information is already clear from the horizontal axis; all I want is the length of the delay. To achieve this, I can:
Then, to delete some individual data labels until only the high and low point labels are left, I can:
My chart is almost telling the story I want it to tell. For some last effects, I'd like to thin the columns and thicken the Max Delay series line. To thin the columns, I can:
To thicken the Max Delay series line, I can:
For one final tweak, I'd like to move the data label callouts so they don't overlap my series. To achieve this, I can:
Now that all the changes have been made, here's my chart. Compared to my original chart, it tells a better, more visually appealing story; and, it helps me make a decision: Flight 5, while it's frequently on time, has higher-than-average delays and a poor max delay record, so Flight 2 would probably be a better choice.
We've designed charts to give you the freedom to do pretty much whatever you'd like in terms of style. The Chart Styles option is great (especially combined with Theme and Chart Colors), because you'll almost always end up with something clean-looking and usable, no matter which style you pick. On the other hand, you can do everything yourself with the Task Pane and have ultimate control over your chart. It's worth noting that combining a lot of Task Pane changes can lead to a visually busy chart; but, used judiciously, you can create a pretty cool chart!
For more details on the Excel charting features mentioned in this post, check out these related topics:
We'd love your thoughts and feedback--please join the conversation in the comments below!
--Alex Mullans, Program Manager, Office Graphics & Visualizations team
A fine overview of excellent software. Thank You.
Glad you enjoyed it. Thanks for reading!
I like what's been done with Excel charts in 2013 for the most part but why did you move the Save as Template option from the ribbon to the shortcut menu? Saving chart templates is one of the best time-saving features of Excel and it's been hidden away.
I do, however, like the fact that the Format dialog boxes and Layout tab were abolished and all those options were moved into task panes. Go task panes!!