Hello everyone.
In this video I will show you how to create all the bar charts.
These are another type of dynamic charts used to emphasize any particular percentage in our presentation
or dashboard.
Obviously in the other video also where percentages shown like this light colored boxes.
So we have 45 percentage to show.
And we have 45 a so-called colored and the others are not color.
Today we will create cards like this.
We're changing the percentage value with 20 percentage of failed to monitor.
So for example if you want to show how popular a particular song is you show it like this ad that is
already liked by 80 percent of people.
If you change the value of this percentage you can see it a moment that now shows 20 percent or so that
popular song is only 20 percent liked by people.
Similarly you can use the other infographics of the Like button where 69 percent of people like this
particular item.
Now let us know on how to create such dynamic charts.
Let us consider that I am collecting donations for a good cause.
My aim is to collect a hundred thousand in this sale.
I will keep updating the total value of donations accumulated this sale will give the percentage of
my aim achieved.
Now I want to represent this percentage as percentage of the piggy bank failed.
I have already have an image of this piggy bank.
So if I have 50000 which will be 50 percent of the target I want my piggy bank to be halfway when yellow
or golden color.
If you closely observe the thermometer charred you can see that it is a column chart where the length
of the column proportion is increasing or decreasing with the change in percentage value.
In fact that is duplicate.
The trick is to overlay an image with hollow transparent center over the bar chart.
This budget will really presenting the percentage value.
So if I go back to my piggy bank First I will create a column chart I will go to insert select column
chart
so you can see I have created a column of 50 percent each.
This is the only value that I want to show.
I'll click okay and close this.
I'll have to change these percentage values the access that we have on the vertical time from zero to
a hundred percent for that I'll go and former Texas intellect the values 0.
It will have a monopoly of zero and the maximum value of one
book
I chose these formatting options.
If I take two donations to eighty thousand
you can see the percentage of the data and the valuing jar.
Also increased now I have to format this chart and to make it ready so that when I owe a lady piggy
bank image or this it will represent the percentage of donations that I have received.
So to do that I will first remove the extra things from this chart.
I remove the chart title.
Remove the login box clear detailed area clear the vertical axis and keep the grid lines for now so
that I know or does the range.
We have this chart ready.
I'll bring this image to the top so that it overlays the chart.
Now I'll try to get this position correctly.
Important thing to note when you're setting these two images together is the zero of your bar chart
should be the lowest point of your image and the hundred dollar bar chart should be the highest point
of your image.
That's why we can degrade land so that we can match the top and bottom of a bar chart with the image
now that we have done it.
Remove the bar chart under the image to the Daniel vertical position.
You need to hold the shift key.
And then move the chart.
Your job is in the right position.
You need to increase the width of this chart.
Too late jarred Chile titties repeatedly at you can see that the piggy bank is now 80 percent full.
You can change the color.
As I said I want a golden yellow will change.
Remove the boulder
no water
and no I'll remove the reclaimed remove the border of the chart also.
You can see at 80 percent my piggy bank is 80 percent well if I change your donations two hundred percent
two hundred thousand might be you will be a hundred percent food
so your info graphic is ready you can use it in presentations audio dashboards that is all for more
such videos please visit a YouTube channel.
Start at the academy or if you want to learn Excel overall.
Check out our course on udemy.
Thanks.