How to Make a Speedometer Chart in Excel | Modern and Beautiful | Interactive with Click
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel...
#Excelentejoao #Excel #Dashboard
In this Excel video lesson, we'll learn how to create a speedometer chart in Excel for use in reports, Excel dashboards, or even for use in Excel presentations.
To create the speedometer chart in an Excel spreadsheet, we'll need a database, chart and pointer settings, use an options box through the Developer tab, the Index function, and finally, create the pie chart with a donut.
The Excel database is the first step in creating any chart in Excel. It's from our Excel table that the charts will pull information.
The Chart and Pointer settings are auxiliary calculation columns in Excel that we'll use to create the dynamic chart and interactive chart in Excel. These auxiliary columns are used to calculate the graph's performance in the Excel spreadsheet. Here, we can also configure the speedometer graph's pointer size and the number of rating categories.
Regarding the rating categories, for example, if you use good, fair, and poor, there will be three types of criteria, but you can use as many criteria as you need.
The Options Box in the Developer tab will help us create a complete list with all the names we have. This list is automatic. Whenever you add a value, the list of options updates automatically.
The options box is also known as a drop-down list, name box, option list, value list, data box, etc.
The Developer tab is not enabled in Excel by default; that is, the Develop tab does not appear in Excel. To enable it, simply right-click the toolbox and click on the Tools tab options. You can then select various tabs, tools, and features that Excel has, as well as the Developer tab, where we have several important tools and features that can greatly help us in our daily work and in the Excel market.
The Index function returns a value or a reference to a value from a table or range. There are two ways to use the INDEX function: return the value of a specified cell or an array of cells. In this free Excel tutorial, using the name selected in the name box, we'll use the Index function to return the revenue value for the selected salesperson.
And now, just create the speed chart in Excel. To create this chart, we'll need to combine two charts into one in Excel: a Donut Chart with a Pie Chart.
The Donut Chart in Excel will represent each of the categories.
The pie chart will create the pointer visualization.