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"
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть