Como Fazer Gráfico de Velocímetro no Excel | Moderno e Bonito | Interativo com Clique

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... In this Excel video lesson, we will learn how to create a speedometer chart in Excel to use in reports, Excel Dashboards, or even to use in Excel presentations. To create the Speedometer Chart in the Excel spreadsheet, we will need a database, the chart and pointer settings, use an options box through the developer tab, Index function, and finally, create the pie chart with donut. The Database in Excel is the first step in building any chart in Excel. It is from our Excel table that the charts will pull the information. The Chart and Pointer settings are auxiliary calculation columns in Excel that we will use to build the dynamic chart and interactive chart in Excel. It is from these auxiliary columns that the operation of the chart will be calculated in the Excel spreadsheet. Here we can also configure the dimensions of the speedometer graph pointer and the number of evaluation categories. Regarding the evaluation categories, for example, if you use good, regular and bad, 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 any value, the list of options is automatically updated. The options box is also known as a drop-down list, name box, list of options, list of values, 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 on the toolbox and click on the tool tab options. Then you can select several tabs, tools and features that Excel has, as well as the developer tab, where we have several important tools and features that can help us a lot in our daily lives and in the job market with Excel. The Index Function returns a value or a reference to a value from within 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 by the name box, we will use the index function to return the revenue value for the selected salesperson. And now, all we need to do is create the speed chart in Excel. To create this chart, we will need to combine two charts into one in Excel. The Donut Chart with the Pie Chart. The Donut Chart in Excel will be responsible for representing each of the categories. The pie chart will be responsible for creating the pointer visualization. #ExcellentJoão #Excel #Dashboard