Step 1: Use Any Excel
First open an excel workbook
And create few columns for names. Here I am using Value1 through Value4 for ease of representation.
Now put real values to represent the variables. Putting values between 0 to 100 for ease of understanding. One can use any value they like, or take real time values from any data source.
Step 2: Graph Appears
Color the bars as you like. I have used red to give some hyper activity feal.
Step 3: Stabilizing the Graph
Setting the minimum and maximum value freezes the graph. Or else the max and min value of the graph is used, which hampers the graph to a considerable limit. Skip this step if you want to see what I mean
Step 4: Removing All That Are Not Required
Step 5: Masking
I made the mask in powerpoint using the union and subtraction tool.
The mask is also provided within the excel file.
Step 6: Finally
Many other masking can be used as required. The default mask is provided within the excel.
The excel file has been changed a little to make it more dynamic. I have added the random command to show how it works. To use this just open the excel and use the (F9) button to see it work.