3D Glass Fill Infographics

3d Glass Fill Chart

Dynamic 3D Glass Fill Infographics

In this post, we will learn how to create Dynamic 3D Glass Fill Infographics in Excel. This is very beautiful chart and you can use it in dashboard and reports to present the performance% against the target. This is one of the best substitute of 100% Stacked Column and Target vs. Actual chart  in Excel.

Below is the snapshot of Dynamic 3D Glass Fill Infographics.

Let’s create this chart from scratch.

Please follow the below steps to create this chart in Excel.

  • Open Excel application and save it as 3D Glass Fill Infographics
  • Rename this ‘Sheet1’ to ‘Infographics’
  • Prepare the actual raw data
  • Make the duplicate of the above dataset and modify as per below charts
  • As we have already Zone and Sales% columns in actual data-set, we need to add 3 more columns in the table. Please refer the below mentioned modified table and replicate the same in Excel sheet
  • Select the modified table and go to Insert Tab then select ’100% Stacked Column’ from 2D Column chart
  • Now, right click on Chart and click on ‘Select Data…’. In ‘Select Data Source’ dialog box, click on ‘Switch Row/Column’ and then click on ‘OK’
  • Delete ‘Chart Title’, ‘Legend’, ‘Gridlines’ and ‘Vertical Axes’ from the chart. Chart will look like the below one after deleting these elements
  • Right click on ‘Bottom Cap’ series and click on ‘Format Data Series…’
  • In ‘Format Data Series’ pane, click on ‘Fill & Line’ (paint bucket icon) then expand the ‘Fill’ and select ‘Gradient fill’, ‘Type’ as ‘Linear’ and ‘Direction’ as ‘Linear Right’
  • Now, set the 7 ‘Gradient stops’, their positions, colors and transparency as per below table
    Gradient StopsColorPositionTransparency
    1stBlack Text 10%0%
    2ndWhite Background 111%0%
    3rdWhite Background 1 Darker 15%29%0%
    4thBlack Text 138%0%
    5thBlack Text 192%0%
    6thWhite Background 1 Darker 15%96%0%
    7thBlack Text 1100%0%
  • Post applying the Gradient’s settings, chart will look like the below one
  • Now click on ‘Top Cap’ series and select the ‘Gradient Fill’ to apply the previously applied settings to selected series (Excel will automatically apply the previous settings)
  • Now, click on ‘Sales%’ series (filled with orange color in above) then go to ‘Format Data Series’, Click on ‘Fill & Line’ and select ‘Gradient fill’
  • Set the 7 ‘Gradient stops’, their positions and transparency as per below table
    Gradient StopsColorPositionTransparency
    1stRGB# 240 - 194 - 450%0%
    2ndRGB# 244 - 210 - 10211%0%
    3rdRGB# 244 - 210 - 10225%0%
    4thRGB# 200 - 156 - 1442%0%
    5thRGB# 200 - 156 - 1490%0%
    6thRGB# 244 - 210 - 10296%0%
    7thRGB# 240 - 194 - 45100%0%
  • Post applying the Gradient’s settings on ‘Sales%’ series, chart will look like the below one
  • Keep the color of ‘Sales%’ of North as it is. Change the gradients color of ‘Sales%’ series of South, East and West as per RGB colors available in below table
    Gradient StopsNorthSouthEastWest
    1stRGB# 240 - 194 - 45RGB# 248 - 137 - 56RGB# 246 - 20 - 58RGB# 69 - 192 - 255
    2ndRGB# 244 - 210 - 102RGB# 250 - 163 - 98RGB# 248 - 78 - 106RGB# 113 - 208 - 255
    3rdRGB# 244 - 210 - 102RGB# 250 - 163 - 98RGB# 248 - 78 - 106RGB# 113 - 208 - 255
    4thRGB# 200 - 156 - 14RGB# 207 - 93 - 7RGB# 162 - 43 - 48RGB# 51 - 95 - 186
    5thRGB# 200 - 156 - 14RGB# 207 - 93 - 7RGB# 162 - 43 - 48RGB# 51 - 95 - 186
    6thRGB# 244 - 210 - 102RGB# 250 - 163 - 98RGB# 248 - 78 - 106RGB# 113 - 208 - 255
    7thRGB# 240 - 194 - 45RGB# 248 - 137 - 56RGB# 246 - 20 - 58RGB# 69 - 192 - 255
  • After applying gradients color to ‘Sales% series for South, East and West Axes, chart will look like the below one
  • Now, click on ‘Empty Glass’ series in chart (filled with dark gray color in above graph) then go to ‘Format Data Series’, Click on ‘Fill & Line’ and select ‘Gradient fill’
  • Set the 7 ‘Gradient stops’, their positions, colors and transparency as per below table
    Gradient StopsColorPositionTransparency
    1stBlack Text 14%76%
    2ndWhite Background 113%86%
    3rdWhite Background 1 Darker 15%20%100%
    4thBlack Text 136%80%
    5thBlack Text 189%92%
    6thWhite Background 1 Darker 5%96%42%
    7thBlack Text 1100%73%
  • After applying the gradients stops, color, positions and transparencies, chart will look like the below one
  • Select the Horizontal Axes, change the Font name as ‘Browallia New’; Font size to 20 and Font color to Black
  • Select the ‘Upper Cap’ series then click on plus icon (available at the top right corner of the chart) then tick the Data Labels and select ‘Inside Base’
  • Right click on Data labels then click on ‘Format Data Labels…’
  • In ‘Format Data Labels’ pane, select the ‘Value From Cell’ and select the range of ‘Sales%’. Deselect the ‘Value’ and ‘Show Leader Line’ then close the ‘Format Data Labels’ pane
  • Now, select the data labels again, change the Font name as ‘Browallia New’; Font size to 24 and Font color to Black
  • Select ‘No Outline’ for Horizontal Axes and Chart from the ‘Format Tab’ in ‘Shape Styles’ group
  • Now, our chart is ready, and the final chart will look like below one

Please click on below button to download the 3D Glass Fill Infograpics.

Click to download

LEAVE A REPLY

Please enter your comment!
Please enter your name here