Partners,,,, russianxnxx

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


Also check out Infographics Charts in Excel – Part 1 

    ⬇️ Pop in your Name & Email to get the file!


    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...