Moving Man Chart

A Chart for KPI Metrics

Moving Man Chart is very innovative chart to show the KPI Metrics like Service Level.

Moving Man Chart
Moving Man Chart

Below are the steps to create the Moving Man Chart in MS Excel

To create the moving man chart we need below support data:

  • Service Level (or your Metric Name) and Service Level Performance(this cell will be changed with a formula later on)
  • Image Width take as 5%
  • Remaining Part – put formula =”100%-H1
Support Data
Support Data
  • Select Range “G1:H3” and go to Insert>>Charts>>2D Bar>> Insert Stacked Bar Chart
Insert 2D Stacked Bar Chart
Insert 2D Stacked Bar Chart
  • Select the chart and go to Chart Tools>>Design Tab>>Click on Switch Row/Column
Switch Row/Column
Switch Row/Column
  • Go to Format Tab and change chart height as 1.2″
Chart Size
Chart Size
  • Remove the Chart Title, Gridlines, and Axes >> Primary Vertical
Chart Elements
Chart Elements
  • Right Click on chart and click on Format Data Series
Format Data Series
Format Data Series
  • In Series option take the Gap Width as 0%
Change Gap Width
Change Gap Width
  • Right Click on Horizontal Axis and click on Format Axis
Format Axis
Format Axis

 

  • Change the Axis option as below:
    • Take Minimum as 0 (If it is already 0 then still change it so that it can be changed to Reset from Auto)
    • Take Maximum as 1.05 (If it is already 1.05 then still change it so that it can be changed to Reset from Auto)
    • Take Major as 0.1 (If it is already 0.1 then still change it so that it can be changed to Reset from Auto)
Axis Option
Axis Option
  • Double click on the blue slice and fill color as No Fill
Fill Color as No Fill
Fill Color as No Fill
  • Double click on the gray slice and fill color as No Fill
Fill Color as No Fill
Fill Color as No Fill
  • Click on the worksheet anywhere and go to Insert>>Click on symbol
Symbols
Symbols
  • In Symbol window select Font Webdings
  • Scroll down and select Webdings-130 (A man icon)
  • Click on Insert button
Symbol window
Symbol window
  • Copy  the cell wherein symbol was inserted.

 

Copy the cell
Copy the cell
  • Paste special as a picture.
Paste Special as Picture
Paste Special as Picture
  • Make the size of picture bigger as give below in the image.
Change the Size
Change the Size
  • Select the Picture and go to Format>>Crop
  • Crop the picture to remove the extra blank area.
Crop Picture
Crop Picture
  • Do not leave any extra are while cropping as given below image
Remove Extra Area
Remove Extra Area
  • After cropping successfully, copy the picture (Select the picture and press Ctrl + C)
  • Select the orange slice in the chart and paste (press Ctrl + V)
Paste Image in the chart
Paste Image in the chart
  • Select the Chart area
  • Go to Format>>Shape Fill>>Fill as No Fill
Fill Chart Color as No Color
Fill Chart Color as No Color
  • Go to Format>>Shape Outline>>Select No Outline
Shape Outline
Shape Outline as No Outline
  • Go to Insert>>Shapes>>Insert a Rectangle
Insert Rectangle
Insert Rectangle
  • Take the Rectangle width bigger than the chart width
Rectangle Size
Rectangle Size
  • Right Click on the Shape and click on Format Shape
Format Shape option
Format Shape option
  • Click on Effects button in Format Shape options
Effect button
Effects button
  • Under 3-D Rotation, click on Presets
Presets Option
Presets Option
  • Under the Perspective, select the Perspective Relaxed
Perspective Relaxed
Perspective Relaxed
  • After Select the Perspective Relaxed Change the Y Rotation angle as 284.6°
  • Click on 3-D Format Option.
Change Y Rotation
Change Y Rotation
  • In the 3-D Format option Select the Top bevel as Circle
Top Bevel
Top Bevel
  • Change the Depth  as 15 pt
Depth of Image
Depth of Image
  • Right click on the image and click on Send to Back
  • Adjust the Image with the chart.
Send to Back
Send to Back
  • Put your Active Service Level (Your Performance Metric) on range “F1”
  • On Range “H1” Put formula (F1-2.5%)

Note: Since Image width has been taken 5%, hence the formula on range “H1” is “F1- half of Image Width” is being taken so that image will displayed on the chart in exact position.

Active Service Level
Active Service Level

 

  • Right click on the man image (in the chart)
  • Click on the Add Data Labels
Add Data Labels
Add Data Labels

 

  • Select the 5% (Data label on the chart)
  • Go to formula bar and click on range “F1”
Connect data label with cell value
Connect data label with cell value

Our Moving Man Chart is ready. Please download the excel file for practice.

The Moving Man chart
Click on the chart to download the excel file

Video Tutorial for The Moving Man Chart: