Infographic Chart in Excel Part 2

In Part 2 of Infograhic Charts, I’ll share with you to create this interesting infograhic in Excel. Here we have a single human icon, which dynamically gets filled depending on the value chosen in the drop down

Here is how it is created..

 

Let’s deconstruct this Chart first..

Infographic Chart in Excel Part 2 - 2

Nice Illusion.. isn’t it ? Here is what is happening

  1. A dummy (human) shape of the same size is neatly placed on top of a stacked column chart
  2. The human shape is transparent and the outside region is filled with white color. Notice when I color it yellow

So we need 2 things to create a chart like this

  1. A Stacked Chart – That is simple you can create it
  2. Need a human shape which is hollow from inside

 

Watch How to Create a Transparent Human Shape in PowerPoint


Now you can simply copy and paste the hollow (human) Infographic in Excel

 

Create the Stacked Chart

Infographic Chart in Excel Part 2 - 2

Note that the stacked chart has 2 parts

  1. In Blue – Glucose Levels
  2. In Grey –  The Empty Part

 

All that you have to do now is to carefully place the hollow (human) infographic shape on top of the stacked chart and you are done 🙂 Make sure that the human shape is white in color

 

DOWNLOAD THE FINISHED CHART HERE

 

Also check out Infographics Charts in Excel – Part 1 

 

Some More Interesting Charting Tricks

  1. Customize the Markers of a Chart
  2. Dynamically encircle point in a Line Chart
  3. Draw a Chart with 1 Key Stroke
  4. Add a Total Bubble at the end of the Line Chart
  5. Dynamically Highlight Max and Min Points in your Chart
  6. Highlight Any Bar of a Column Chart

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI