GRÁFICO com REDIMENSIONAMENTO AUTOMÁTICO EXCEL

CLICK HERE TO LEARN MORE ABOUT THE COMPLETE IMPRESSIVE EXCEL COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE MINI COURSE ON DASHBOARDS: http://bit.ly/2XzWSOJ To receive daily content on Excel, VBA and Power BI for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- ► Spreadsheet used in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/g... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- TOP Videos: ► VLOOKUP - Complete Step by Step (without complications)    • PROCV - Passo a Passo Completo (sem compli...   ► How to make your Excel spreadsheet more beautiful and impress your boss    • Como deixar a planilha excel mais bonita e...   ► The 5 BASIC Excel FORMULAS that you MUST LEARN before VLOOKUP    • As 5 FÓRMULAS BÁSICAS do Excel que você TE...   ► Pivot Table - How to make an Excel Pivot Table in 5 steps!    • Tabela Dinâmica - Como fazer Tabela Dinâmi...   ► IF Function - I'll explain how to make the IF formula on the beach!    • Função SE - Te explico na praia como fazer...   ----------------------------------------------------------------------- In today's video, we're going to teach you a very popular topic here: how to create an Excel chart with automatic resizing! What would that be? A chart in Excel, which can be a line, column, pie chart, or any other type, that automatically includes new information! In this video, I'll show you everything from the basics of how to make charts in Excel to the main objective of the class, which is to create an expandable chart in Excel. To be able to create our automatic Excel chart, we're going to need two formulas. The first is the Excel shift, which is used to shift cells or ranges of cells as many rows or columns as we need. We will use this formula to shift the ranges that we will use within the graph. The second formula that we will use is the Excel count. This function is used to find out how many values ​​there are in a range of cells. The Excel count formula will be useful in this case to find out how much information we have filled in the data range to know how many rows we will shift our original range. In our step-by-step guide on how to make an automatic graph in Excel, we will also need to use another Excel tool, which is the Name Manager tool. This tool will be essential to understand how to make a graph in Excel, especially when this graph starts to have automatic resizing. ----------------------------------------------------------------------- #excel #vba #hashtagtraining