Creating an 80/20 chart or a Pareto chart in Excel used to take several steps including adding an extra column for percentage, sorting and then making a combination chart with a column and then line chart. With Excel 2019 or higher, all you need is a two column table and click insert a histogram (Pareto chart). And there's no sorting of the table needed! Here's an Excel #shorts video to show you how.
🔔 SUBSCRIBE to my channel ➜ [ Ссылка ]
🏫 Excel Training ➜ [ Ссылка ]
📚 Excel Books & Tech Gear ➜ [ Ссылка ]
⚙️ Tools: Screencasting ➜ [ Ссылка ]
⚙️ Tools: Microsoft Office ➜ [ Ссылка ]
⚙️ Tools: TubeBuddy ➜ [ Ссылка ]
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
[ Ссылка ]
#excel
#msexcel
#doughexcel
-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
[ Ссылка ]
-~-~~-~~~-~~-~-
Quick Pareto Chart - Excel #Shorts
Теги
doughmicrosofttipstrickstutorialtrainingeasysimplelearnwindowsbasichow-tohowtohow tochartchartsgraphsdoug hdoughexceldoug h excelcreatemakeexcel functionexcel formulaexcel chartexcel dashboardexcelpowerpointdataanalyzeadvancedfreeformulasdownloadonlinexlsvlookuppower bipower pointvizPowerpointdata vizlookupfinanceanalysisbusinesspower query