Excel is one of the most useful Microsoft tools, it is widely used by companies to manage their accounting, among other things. When it comes to presenting data that is understandable in Excel, an Excel speedometer chart always comes out. Therefore, in this article we will teach you how to create a speedometer chart in Excel.
Creating a speedometer chart in Excel
In Excel, you can create many types of charts of one or more sheets, with the program’s wizard, but to make a speedometer chart in Excel, you must take alternate routes. The first thing you should do is open a sheet in excel and create 2 columns with 11 rows. In the first row will be the titles, percentages and scales.
In the percentage column, place the percentages you want to show and in the scale column a 1 will be shown, except for 100%, since in this the total sum of the scales will be displayed. Taking into account the mentioned details, perform the following steps:
You may also be interested in:
- Shade the data and click on the toolbar create pie chart
- Now, you need to delete the title and captions.
- Then, you must change the angle of the graph and to do so click on the right button on the graph and then click on ‘Format data series.’
- Once there, enter 270 ° in ‘Angle of the first slice’ and hit enter.
- Once this is done, you need to hide half of the ring. For that, click just on that part of the box, then open Data Format and select ‘no fill’
- You can choose different colors, for example, yellow, green, red among others.
- Add the data labels, by right-clicking the chart and select label format, then click label value and the interval button.
- Select the percentage range, uncheck the value and label guide to finish manually moving each percentage on the graph placing them in the place you want.
Once we have our green, yellow and red color separations ready, we have to make the arrow, which is the one that will show us the result of the indicator, do the following:
- In a cell write 50% this number will allow the arrow to be functional, to create the degrees you will multiply this 50% with the function Pi, example: D13 * Pi and enter, the result will be in degrees.
- Then create a box for the points in which you should write start ‘X’ ‘Y’, end X, Y. Starting point value is 0 and End point the X = COS (Cosine) and select the degrees and in the ‘Y’ = SEN (Sine) and the value of the degrees. The sine and cosine function will help you.
You may also be interested in:
In the graphic
- Go to the graph, right-click, select data and add an entry with the name of points.
- In the serial values delete and select column X and you accept.
- An orange ring will appear around the graph, right-click only on the orange color and select ‘change type of series graph’.
- There select series 1 as secondary chart and click the points and select ‘scatter chart with smoothed lines’ and accept.
- Doing so the graph will move everything, to invert it, double-click on the ring graph, the option ‘point format’ will appear, place 270 ° as you did at the beginning.
- Double-click on the vertical axis, where it says minimum, put -1 and maximum 1. On the horizontal axis, double-click, put -1 at minimum and 1 at maximum.
- Delete the horizontal and vertical axis, select them and delete.
- Right click and select data. In the series of points you give modify, the X, Y axis will appear. Now select the X axis and accept. Then select the Y axis, accept.
- The speedometer arrow will appear, you can move its direction by changing the percentage number. You will notice that the speedometer measures inverted, to solve it to the cosine you are going to multiply -1 (= D14 * -1)
Speedometer-style graphics are great for performance evaluations, which are also possible to view and work with on iPhone devices.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?