No, next.
We want to create this revenue chart where we are using columns to represent the revenue value.
So this is our data, we have the data of past five years and then we have a projected data of year
2021.
So again, to the chart, we will go to insert and this time we want to call them chart, so we will
click on here and click on to the column.
Now, another simple way to talk is just to select the data you want to contact and then go to chart
and click on the desired chart if you do that.
Excel will try to find out what you are trying to plot on your chart, and it may come at some error
sometimes.
So, for example, here we want your values as horizontal axis.
So instead of that Excel as selected, one, two, three, four as the horizontal axis.
And then Excel has added 2016 2017 era values as a primary axis, as a primary axis or vertical axis.
So even if you insert a chart by this matter, you can edit the data later on.
So, for example, go to select data.
Now, here also you can see that in cities, we have two cities here, revenue, but we want it as a
horizontal axis label, not as a cities.
So you can.
You can remove it from here and then in the horizontal axis instead of this one, two, three, four,
we want years, so.
Select the year with you.
So now our chart is looking good.
We have the revenue figure in the form of columns and we have years in the form of horizontal axis.
We also have a legend and we also have a chart titled.
Now, since this is the projected value.
Year 2021 is a projected value, so we can calarco this column so that other people can easily identify
that this is not a real value.
This is the projected value.
So all the other columns are in orange color.
To mention that you're 20, 21 is a projected value, we will change the color of this column.
So to change the color.
Click on this bar, you will see that all the bars are selected now to select this individual bar,
you have to click on this column.
So once you double click it, you will see that on this column is selected.
Now, go to this Phil and line option and select the color that you want right now.
I will use a gray color.
To highlight that this is the projected value.
Now, you can see that our chart is looking like the chart that we have in the dashboard.