This post is written to get percentage in Bar/Column chart. For example
Consider following table
If we plot this into Column chart then we get following
If we see data labels then we get following options
In general option provided by excel, one can not determine percentage contribution of one zone. One can not get below chart with provided Excel features
Now I will teach you, how to make bar or column chart with percentage.
Step 1: Calculate percentage against Zones
Step 2: Click on Data label in chart i.e. Click on value 20,000 in chart. You will see all data labels are selected.
Step 3 : Now again click on data label and you will see that only one data label is selected
Step 4 : Now click on formula bar and give reference to data cell where percentage value is calculated
Consider following table
If we plot this into Column chart then we get following
If we see data labels then we get following options
In general option provided by excel, one can not determine percentage contribution of one zone. One can not get below chart with provided Excel features
Now I will teach you, how to make bar or column chart with percentage.
Step 1: Calculate percentage against Zones
Step 2: Click on Data label in chart i.e. Click on value 20,000 in chart. You will see all data labels are selected.
Step 3 : Now again click on data label and you will see that only one data label is selected
Step 4 : Now click on formula bar and give reference to data cell where percentage value is calculated
Step 5 : Now repeat this for all column and you will get below chart
This is not hardcoding of values. If you change contribution of zones then chart will automatically change percentage in it.
If you find this post useful then help us grow. Please share our post to your friends and social networking sites. Thanks for visiting us.
No comments:
Post a Comment
Your comments are important for us.