For this, insert a text box and select it and then in the formula bar enter вЂњ=вЂќ and select the pointer values cell, hit ENTER.Exponential Excel function in excel is also known as the EXP function in excel which is used to calculate the exponent raised to the power of any number we provide, in this function the exponent is constant and is also known as the base of the natural algorithm, this is an inbuilt function in excel.

And at last, you need to add a custom data label for the needle (ThatвЂ™s the most important part).

After that, select the label chart and do the same with it by adding labels from the second data table.

From here, select the performance label from the first data table and then untick вЂњValuesвЂќ.

Now, select the data labels and open вЂњFormat Data LabelвЂќ and after that click on вЂњValues from CellsвЂќ.

First of all, select the category chart and add data labels by Right Click вћњ Add Data Labels вћњ Add Data Labels.

In вЂњFormat Data PointвЂќ, go to вЂњSeries OptionsвЂќ and add 5% in вЂњPoint ExplorationвЂќ.В At his point, you have a ready to use SPEEDOMETER (like below), just a final touch is required and that final thing is adding data labels and we need to do this one by one for all the three charts.

For this, select the needle and right click on it and then click on вЂњFormat Data PointвЂќ.

Next, you need to make this needle bit out from the chart so that it can be identified easily.

After this, youвЂ™ll only have the small part left in the pie chart which will be our needle for the SPEEDOMETER.

Now, select both of the large data parts of the chart and apply no fill color to them to hide them.

At this point, you have a chart like below.В Note:В If after selecting a pie chart if the angel is not correct (there is a chance) make sure to change it to 270.

In вЂњChange Chart TypeвЂќ window, select pie chart for вЂњPointerвЂќ and click OK.

After that, select the chart and go to Chart Tools вћњ Design Tabs вћњ Change Chart Type.

In вЂњSelect Data SourceвЂќ window click on вЂњAddвЂќ to enter a new вЂњLegend EntriesвЂќ and select вЂњValuesвЂќ column from the third data table.

For this, right click on the chart and then click on вЂњSelect dataвЂќ.

Now, the next thing is to create a pie chart with a third data table to add the needle. After this, youвЂ™ll have a chart like below.

Again you need to hide below half of the chart by using вЂњNo FillвЂќ for color and I've also added a color scheme for the labels.

In вЂњSelect Data SourceвЂќ window click on вЂњAddвЂќ to enter a new вЂњLegend EntriesвЂќ and select вЂњValuesвЂќ column from the second data table.

At this point, youвЂ™ll have a chart like below and the next thing is to create the second doughnut chart to add labels.

For the rest of the fours data points, IвЂ™ve used fours different colors (Red, Yellow, Blue, and Green).For this, click on only that part of the chart and open вЂњFormat Data PointвЂќ and select вЂњNo FillвЂќ. After this, you need to hide below half of the chart.In вЂњFormat Data SeriesвЂќ, enter 270В° in вЂњAngle of first sliceвЂќ and hit enter.From here the next thing is to change the angle of the chart and for this right click on the chart and then click on вЂњFormat Data SeriesвЂќ.

Once you click OK, youвЂ™ll have a doughnut chart just like below.After that, select the вЂњValueвЂќ column from the first data table. In the вЂњSelect DataвЂќ window, click on вЂњLegend EntriesвЂќ and enter вЂњCategoryвЂќ in the name input bar.Now, right-click on the chart and then click on вЂњSelect DataвЂќ.First of all, go to Insert Tab вћњ Charts вћњ Doughnut Chart ( with this youвЂ™ll get a blank chart).To create a SPEEDOMETER in Excel, you can use the below steps:

Stat measures in excel symbols