Getting started with a combo chart<\/span><\/h3>\nI’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.<\/p>\n
\n- I edited the Chart Title by triple-clicking on it.<\/li>\n
- I added Axis Titles to all axes by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol) and checking the Axis Titles<\/strong> box.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\")
<\/p>\n
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.<\/p>\n
Using Chart Colors<\/span><\/h3>\nSpecifically, that orange is a bit bright for my taste. To change it:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click the Change Colors<\/strong> button.<\/li>\n
- Click a set of Chart Colors<\/strong>.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/1732.StoryWithCharts_Image2.png\")
<\/p>\n
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.<\/p>\n
Using Theme Colors <\/span><\/h3>\nNow, 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Page Layout<\/strong> tab, then click the Colors<\/strong> button.<\/li>\n
- Click a set of Theme Colors<\/strong>.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/2727.StoryWithCharts_Image3.png\")
<\/p>\n
Do keep in mind that changing the Theme Colors affects your entire workbook (including other charts and theme-dependent objects like SmartArt).<\/p>\n
Using Chart Styles<\/span><\/h3>\nChart 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click a Chart Style<\/strong> from the gallery.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/7065.StoryWithCharts_Image4.png\")
<\/p>\n
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.<\/p>\n
Using the Task Pane to customize your chart<\/span><\/h3>\nIt’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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/5468.StoryWithCharts_Image5.png\")
<\/p>\n
You also can choose an element and open the Task Pane from the Ribbon. To do so:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Format<\/strong> tab, then use the dropdown menu to select an element.<\/li>\n
- Click Format Selection<\/strong>.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/0435.StoryWithCharts_Image6.png\")
<\/p>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/0878.StoryWithCharts_Image7.png\")
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/2705.StoryWithCharts_Image8.png\")
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/8030.StoryWithCharts_Image9.png\")
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/2047.StoryWithCharts_Image10.png\")
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/2402.StoryWithCharts_Image11.png\")
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/6507.StoryWithCharts_Image12.png\")
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/7357.StoryWithCharts_Image13.png\")
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
![](\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3124.StoryWithCharts_Image14.png\")
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
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.<\/p>\n
Using Chart Colors<\/span><\/h3>\nSpecifically, that orange is a bit bright for my taste. To change it:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click the Change Colors<\/strong> button.<\/li>\n
- Click a set of Chart Colors<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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.<\/p>\n
Using Theme Colors <\/span><\/h3>\nNow, 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Page Layout<\/strong> tab, then click the Colors<\/strong> button.<\/li>\n
- Click a set of Theme Colors<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Do keep in mind that changing the Theme Colors affects your entire workbook (including other charts and theme-dependent objects like SmartArt).<\/p>\n
Using Chart Styles<\/span><\/h3>\nChart 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click a Chart Style<\/strong> from the gallery.<\/li>\n<\/ul>\n
<\/p>\n
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.<\/p>\n
Using the Task Pane to customize your chart<\/span><\/h3>\nIt’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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
<\/p>\n
You also can choose an element and open the Task Pane from the Ribbon. To do so:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Format<\/strong> tab, then use the dropdown menu to select an element.<\/li>\n
- Click Format Selection<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
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.<\/p>\n
Using Theme Colors <\/span><\/h3>\nNow, 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Page Layout<\/strong> tab, then click the Colors<\/strong> button.<\/li>\n
- Click a set of Theme Colors<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Do keep in mind that changing the Theme Colors affects your entire workbook (including other charts and theme-dependent objects like SmartArt).<\/p>\n
Using Chart Styles<\/span><\/h3>\nChart 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click a Chart Style<\/strong> from the gallery.<\/li>\n<\/ul>\n
<\/p>\n
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.<\/p>\n
Using the Task Pane to customize your chart<\/span><\/h3>\nIt’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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
<\/p>\n
You also can choose an element and open the Task Pane from the Ribbon. To do so:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Format<\/strong> tab, then use the dropdown menu to select an element.<\/li>\n
- Click Format Selection<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
Do keep in mind that changing the Theme Colors affects your entire workbook (including other charts and theme-dependent objects like SmartArt).<\/p>\n
Using Chart Styles<\/span><\/h3>\nChart 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:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Design<\/strong> tab, then click a Chart Style<\/strong> from the gallery.<\/li>\n<\/ul>\n
<\/p>\n
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.<\/p>\n
Using the Task Pane to customize your chart<\/span><\/h3>\nIt’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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
<\/p>\n
You also can choose an element and open the Task Pane from the Ribbon. To do so:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Format<\/strong> tab, then use the dropdown menu to select an element.<\/li>\n
- Click Format Selection<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
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.<\/p>\n
Using the Task Pane to customize your chart<\/span><\/h3>\nIt’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.<\/p>\n
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.<\/p>\n
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.<\/p>\n
<\/p>\n
You also can choose an element and open the Task Pane from the Ribbon. To do so:<\/p>\n
\n- Select the chart by clicking on it.<\/li>\n
- On the Ribbon, click the Chart Tools Format<\/strong> tab, then use the dropdown menu to select an element.<\/li>\n
- Click Format Selection<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n<\/p>\n
<\/p>\n
Changing individual colors<\/span><\/h3>\nTo 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:<\/p>\n
\n- Click the Fill & Line<\/strong> tab (the paint bucket).<\/li>\n
- Click the Line<\/strong> sub-heading.<\/li>\n
- Click the Color<\/strong> paint bucket to select a red color for the line.<\/li>\n<\/ul>\n
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
Adding and styling data labels<\/span><\/h3>\nNext, 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:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- Add Data Labels by clicking the Chart Elements<\/strong> button (the +<\/strong> symbol), checking the Data Labels<\/strong> box, and using the flyout menu to switch to Data Callouts<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
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:<\/p>\n
\n- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\n
Then, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n
<\/p>\n
Additional effects<\/span><\/h3>\nMy 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:<\/p>\n
\n- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\n
To thicken the Max Delay series line, I can:<\/p>\n
\n- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\n
Manual element positioning<\/span><\/h3>\nFor one final tweak, I’d like to move the data label callouts so they don’t overlap my series. To achieve this, I can:<\/p>\n
\n- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\nNow 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.<\/p>\n
<\/p>\n
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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\n
Telling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n
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:<\/p>\n
- \n
- Select the data labels by clicking on one.<\/li>\n
- In the Task Pane, click the Label Options<\/strong> tab (the bar chart icon).<\/li>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n
- Uncheck the Category Name<\/strong> box.<\/li>\n<\/ul>\n
<\/p>\nThen, to delete some individual data labels until only the high and low point labels are left, I can:<\/p>\n
- \n
- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Delete the selected label by pressing the Delete<\/strong> key or right-clicking and choosing Delete<\/strong>.<\/li>\n<\/ul>\n<\/p>\n
Additional effects<\/span><\/h3>\n
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:<\/p>\n
- \n
- Select the On-time % series by clicking on one of the bars.<\/li>\n
- In the Task Pane, click the Series Options<\/strong> tab (the bar chart icon).<\/li>\n
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
<\/p>\nTo thicken the Max Delay series line, I can:<\/p>\n
- \n
- Select the Max Delay series by clicking on it.<\/li>\n
- In the Task Pane, click the Fill & Line<\/strong> tab (the paint bucket icon).<\/li>\n
- Select a Width of 4 pt by typing or using the arrows.<\/li>\n
- Select a Join type of Miter<\/strong> (which gives each bend the more angular appearance) by using the dropdown menu.<\/li>\n<\/ul>\n
<\/p>\nManual element positioning<\/span><\/h3>\n
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:<\/p>\n
- \n
- Select all data labels by clicking on one.<\/li>\n
- Select an individual label by clicking on it after all data labels are already selected.<\/li>\n
- Click-and-drag the labels to a better position.<\/li>\n<\/ul>\n
The final chart<\/span><\/h3>\n
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.<\/p>\n
<\/p>\nWe’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!<\/p>\n
–Alex Mullans, Program Manager, Office Graphics & Visualizations team<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"
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. Read on to learn how to put chart options to work for you.
\n <\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business"],"yoast_head":"\nTelling a story with charts in Excel 2013 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"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. Read on to learn how to put chart options to work for you. \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-10-02T03:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-22T13:44:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Telling a story with charts in Excel 2013\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"},\"wordCount\":1467,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\",\"name\":\"Telling a story with charts in Excel 2013 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"datePublished\":\"2013-10-02T03:00:00+00:00\",\"dateModified\":\"2022-07-22T13:44:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Telling a story with charts in Excel 2013\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_locale":"en_US","og_type":"article","og_title":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","og_description":"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. Read on to learn how to put chart options to work for you. ","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2013-10-02T03:00:00+00:00","article_modified_time":"2022-07-22T13:44:58+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Telling a story with charts in Excel 2013","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"},"wordCount":1467,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/","name":"Telling a story with charts in Excel 2013 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","datePublished":"2013-10-02T03:00:00+00:00","dateModified":"2022-07-22T13:44:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/migrated-images\/44\/3465.StoryWithCharts_Image1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2013\/10\/02\/telling-a-story-with-charts-in-excel-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Telling a story with charts in Excel 2013"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=895"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=895"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=895"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Change the Gap Width to 410% by typing or using the slider.<\/li>\n<\/ul>\n
- Click the Label Options<\/strong> subheading to expand it.<\/li>\n