Next, we want to create jobs for our expense, vital for advertisement and payroll category, so we
have set a target of 300000 for advertisement budget and two hundred and seventy thousand for payroll
expense.
And we are also tracking the way to the year to date value of our advertisement and payroll expense.
So to communicate this data, we can use the bar chart where our target will be the upper limit of our
expenses, advertisement and payroll expenses and the amount which we have already spent.
Will be highlighted by some other color.
So here we will first select this data and go to insert and click on this Bartter.
Now, this is the default.
Generated by Excel, there is one major problem with this chart here, Excel has kept both of the target
side by side.
So, for example, this one is the 300000 value, which is the target for advertisement.
And this one is the column for Target for payroll.
But we want something different.
We want to target value.
Just soon to the way to devalue.
So in this graph right now, weighted values are just too weighted.
Values on target value of payroll is adjacent to the target value of advertisement.
So to correct this thing, click on this which row and column button.
Here you can see that once you switch it.
It will switch the two columns.
So now we have two categories, advertisement and payroll.
We have a target budget in the form of blue column, and we have divided values in the form of Orange
column.
Now, if you notice in the dashboard, we have overlap these two columns because the span will always
be less than the budget we have allocated.
So it is better to overlap this expense in the front of the budget of that category.
Now, how to do that?
To do that, just select any column.
Go to this series Options, and here you will see series or leape option.
Now, if you increase this series or Leape option, you will see that your columns will start to overlap
on each other.
Now increase a two hundred percent to make a complete overlap.
Oh, you can see that this is the total target and these are the vital values.
We can also at the table, so, for example, if I go to here and click on the table, I can see the
data labels for the target column.
Now, it makes more sense to track how much of the target we have already achieved, for example, here.
We have another column which is saying that we have achieved 70 percent of target in advertisement budget
and 61 percent of target in payroll budget.
Now it's better to display this information over this column.
Instead of the total allocated budget, this total allocated budget is not making much sense.
It would be better if we can display this percentage value on top of these two columns, so to do that,
just select your.
Data labels and here in label option, you have an option of what value should the data labels contain
now here on the button?
And click on value from cells here, you can select the cells which contain the value you want to display.
So I want to display this percentages.
So I have selected these two values.
Now, once you have selected it, click on OK, and now you can see that we have this percentage value
on top of our columns.
Now, the only thing we need to correct here is the chart titled.
So here.
Will just.
Copied on their own.
Added this chart paper.
So now over this chart is also ready in the next lecture.
We will combine all of these four charts to create a dashboard like this.