In this Excel video tutorial, we are going to learn how to make a actual vs target chart with emojis in Excel or Excel emoticons chart.
Creating this actual target chart in excel is simple, but it has some different and important details to do in our Excel table.
The first step is to have a table in Excel or a database with the information that will compose the column chart.
In this free Excel tutorial, I'm going to use a sales spreadsheet as the basis of my PivotChart, Interactive Chart, Beautiful Chart, and Modern Chart.
We need to set a target for the values for each of the months. Thus, we will be able to know if the value is good or not and use the corresponding emoji to represent this.
To automate this repetitive task in Excel, we are going to use the logical IF function. The Excel IF formula is one of the most important functions in Excel in my opinion. Yeah, it helps us automate tasks and automate repetitive processes of our day to day.
And, after building the formula in excel, we are going to use the shortcut "windows button" plus "period" to enable the choice of emoticons in excel.
After that, just format the chart numbers in Excel so that the emoticon follows the value of each column of the chart.
This chart in Excel can be used for dashboards and reports, professional spreadsheets, to make a presentation at work using Excel. In addition to being a graphic that updates automatically, the icons used, figures, shapes, emoticons, emojis are also updated and changed automatically in order to meet our criteria.
Whenever the goal target is reached, it is Ok, if not, it is a red flag.
These icons are inserted and changed automatically whenever the last update of the Excel worksheet is taken into account.
#JopaExcel #Dashboard #Excel
