{"id":4353,"date":"2022-01-10T00:02:00","date_gmt":"2022-01-10T05:02:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4353"},"modified":"2024-10-21T13:11:46","modified_gmt":"2024-10-21T17:11:46","slug":"excel-humour-2022-01-10-excel-chart-superhero","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2022\/01\/10\/excel-humour-2022-01-10-excel-chart-superhero\/","title":{"rendered":"Excel Humour 2022-01-10 Excel Chart Superhero"},"content":{"rendered":"<p>Sometimes it&#8217;s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it!<\/p>\n<p>Here are a couple of short videos that show how to work with Excel pie charts, and win the battle.<\/p>\n<p><!--more--><\/p>\n<h3>You&#8217;re an Excel Chart Superhero<\/h3>\n<p>If you managed to change the colours in your Excel chart today \u2013 congratulations! You are a superhero!<\/p>\n<figure style=\"width: 400px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/chartcolourssuperman01.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Excel chart superhero\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/chartcolourssuperman01_thumb.jpg\" alt=\"Excel chart superhero\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Excel chart superhero<\/figcaption><\/figure>\n<h3>How to Make a Pie Chart<\/h3>\n<p>A pie chart shows amounts as a percentage of the total amount. Other charts, such as a bar chart or a column chart, are better for showing the differences between amounts.<\/p>\n<p>If you need a pie chart, create a simple one, without special effects such as 3-D. Then, format the data labels, so the data is easier to understand. Watch this short video to see the steps for making and formatting an Excel pie chart.<\/p>\n<p>There are <a href=\"https:\/\/www.contextures.com\/excelpiechartexamples.html\">written steps on my Contextures website<\/a>.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/fnE-Yq771nM?rel=0\" width=\"450\" height=\"283\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3>Add Pictures to a Pie Chart<\/h3>\n<p>It&#8217;s usually best to keep things simple, but in this example, pictures are added to the slices, to show types of pizza toppings.<\/p>\n<p>Watch this video to see the steps for adding pictures in Excel pie chart slices, and there are <a href=\"https:\/\/www.contextures.com\/excelpiechartexamples.html#addpics\" target=\"_blank\" rel=\"noopener\">written steps on my Contextures site<\/a>.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/mArCHukpOTI?rel=0\" width=\"450\" height=\"283\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3>More Excel Chart Tutorials<\/h3>\n<p>There are more Excel chart tutorials and videos on my Contextures site, and here are a few examples, with links to the instructions.<\/p>\n<h4>Gantt Charts<\/h4>\n<p>Although Excel doesn&#8217;t have a built in Gantt chart type, you can follow the steps below to create a simple project plan in Excel, with a Gantt chart timeline.<\/p>\n<p>In the example shown below, I created a simple Gantt chart, to show the steps in working on a company budget. You can see when each step starts, and when it ends.<\/p>\n<p>There are instructions on this page: <a href=\"https:\/\/www.contextures.com\/excelganttchartprojectplan.html\">Gantt Charts<\/a><\/p>\n<figure style=\"width: 410px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/ganttchart22.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Excel Gantt chart with budget steps\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/ganttchart22_thumb.png\" alt=\"Excel Gantt chart with budget steps\" width=\"410\" height=\"250\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Excel Gantt chart with budget steps<\/figcaption><\/figure>\n<h3>Line Chart with Target Range<\/h3>\n<p>In a line chart with monthly sales data, you can add a shaded target range, behind the line. That will give you a quick indication of which months didn\u2019t fall within the expected range.<\/p>\n<figure class=\"wp-caption alignnone\"><a href=\"https:\/\/contexturesblog.com\/wp-content\/uploads\/2022\/03\/linecharttargetrange01.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Line Chart with Target Range\" src=\"https:\/\/contexturesblog.com\/wp-content\/uploads\/2022\/03\/linecharttargetrange01_thumb.png\" alt=\"Line Chart with Target Range\" width=\"450\" height=\"281\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Line Chart with Target Range<\/figcaption><\/figure>\n<h4>Video: Line Chart Shows Target Range<\/h4>\n<p>In this video, I show all the steps for setting up this chart. Also, my Contextures site has written steps for making a <a href=\"https:\/\/www.contextures.com\/excelcharttargetrange.html\" target=\"_blank\" rel=\"noopener\">line graph with target range<\/a>.<\/p>\n<p><iframe loading=\"lazy\" title=\"Create an Excel Line Chart With Target Range\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/7Y9lhA50kwo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h4>Combination Charts<\/h4>\n<p>If you use two different chart types in a single chart, it&#8217;s called a combination chart, like the line-column chart shown below.<\/p>\n<p>In this example, each series is on a different axis, so you can compare the amounts (thousands), with the number of cases (hundreds). If both were on the same axis, the cases would be almost impossible to see, because those numbers as so small.<\/p>\n<p>Get the instructions on this page, on my Contextures site: <a href=\"https:\/\/www.contextures.com\/linecolumncombinationchart.html\">Line-Column Chart 2 Axes<\/a><\/p>\n<figure style=\"width: 391px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/combinationlinecolumn.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Excel combination chart line column\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/combinationlinecolumn_thumb.png\" alt=\"Excel combination chart line column\" width=\"391\" height=\"221\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Excel combination chart line column<\/figcaption><\/figure>\n<h4>Cluster Stack Chart<\/h4>\n<p>Or, get really fancy, and make a cluster stack chart, which is a combination of a stacked column chart, and a clustered column chart. In the example shown below, the chart has:<\/p>\n<ul>\n<li>a <strong>Cluster<\/strong> of columns for each region (East, West, North, South)<\/li>\n<li>a<strong> Stack<\/strong> in each column, with a different coloured segment for each season in the year<\/li>\n<\/ul>\n<p>You&#8217;ll find written steps and a video on my Contextures site: <a href=\"https:\/\/www.contextures.com\/Excel-Addins-Charts-Cluster.html\" target=\"_blank\" rel=\"noopener\">Excel Cluster Stack Chart<\/a><\/p>\n<figure style=\"width: 450px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/clusterstackchart02.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Excel cluster stack column chart\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/clusterstackchart02_thumb.png\" alt=\"Excel cluster stack column chart\" width=\"450\" height=\"266\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Excel cluster stack column chart<\/figcaption><\/figure>\n<h4>In-Cell Charts<\/h4>\n<p>You can even make charts in worksheet cells, by using the Excel REPT function. In the example shown below, I used the Wingdings font to create the squares, and the bar length is based on the number in column B. To create the column, for quantities less than 60, I added <a href=\"https:\/\/www.contextures.com\/xlcondformat01.html\">conditional formatting<\/a>.<\/p>\n<p>Get the instructions on this page: <a href=\"https:\/\/www.contextures.com\/excelreptfunctionexamples.html\" target=\"_blank\" rel=\"noopener\">Excel REPT Function Examples<\/a><\/p>\n<figure style=\"width: 385px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/rept01.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Excel in-cell chart with REPT function\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/01\/rept01_thumb.png\" alt=\"Excel in-cell chart with REPT function\" width=\"385\" height=\"206\" border=\"0\" \/><\/a><figcaption class=\"wp-caption-text\">Excel in-cell chart with REPT function<\/figcaption><\/figure>\n<p>_______________________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes it&#8217;s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it! Here are a couple of short videos that show how to work with Excel pie charts, and win the &hellip; <a href=\"https:\/\/exceltheatre.com\/blog\/archives\/2022\/01\/10\/excel-humour-2022-01-10-excel-chart-superhero\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel Humour 2022-01-10 Excel Chart Superhero&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":4347,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4353"}],"version-history":[{"count":4,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4353\/revisions"}],"predecessor-version":[{"id":4547,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4353\/revisions\/4547"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4347"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}