Como Fazer Curva ABC no Excel | Gráfico com Separação de Categorias Automáticas

🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel... #Excelentejoao #Excel #Dashboard In this Excel video tutorial, we'll learn how to create an ABC curve chart in Excel, a Pareto chart, or an 80/20 chart in Excel. The ABC curve chart in Excel is an excellent tool for analyzing and visualizing which products, items, services, and projects bring us the best results. In this free Excel tutorial, using a practical, everyday example that could be found in the job market, we'll learn how to create a complete ABC curve chart in Excel. Besides being a modern and beautiful chart that you can use in your presentations, Excel reports, and Excel dashboards, it's a dynamic chart and an interactive chart. In other words, whenever you update your table with new information, the chart will automatically update for you. The first step to creating a Pareto chart in Excel is to have a database—that is, the information you'll use to create the chart. In this example, I'll use two columns: the first with the names of the products in my company's inventory and the other with the total sales value of each product. After that, I'll sort the values from highest to lowest, and sort the revenue values in descending order. This way, I'll be able to fill in the remaining columns needed to create this chart in Excel. The remaining columns are the accumulated value, the value's representativeness in relation to the total, the sum of the accumulated percentage, and a column with each product's category classification, which can be category A, category B, or category C. This last column, the status, where we'll enter the classification of each product category, to automate this task and automate this process, instead of filling in row by row manually, we'll use the IF function in Excel. Since the IF function allows us to use only one criterion, allows us to use only one condition, I'll need to use the IF function within the IF function. In other words, we'll use a function within another function here in Excel, a function called a nested function. We'll use the nested IF function to solve this problem with the three categories we have: A, B, and C. This way, we'll be able to create our ABC curve chart here in Excel. Now, just select the information and place it in the column chart and another part in the line chart. However, to avoid using two separate charts, we'll create a combination chart—that is, we'll combine two charts into one here in Excel: Column Chart and Line Chart. After finishing the chart, we can make some adjustments to the chart's layout and design so that our chart can be both attractive and modern in Excel. This way, we can use it in professional presentations, reports, and spreadsheets.