Скачать с ютуб How to create chart data from Power Query | Excel Off The Grid в хорошем качестве

How to create chart data from Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the code ★ https://exceloffthegrid.com/power-que... ★ About this video ★ Recently, in our training academy, charting legend Jon Peltier demonstrated the best data structure required for working with Charts in Excel. Following this, one of our academy members asked this question: "I am trying to use what Jon was teaching in the charting master class for stacked legends. Is there anyway to get that layout out of power query or power pivot or data model or ????" In this post, I want to provide 1 answer that question, and take a deeper look at how to create chart data with Power Query. 0:00 Introduction 0:48 Ideal shape for chart data 2:46 Example data 3:08 Basic chart layout 5:58 Power Query custom function 7:17 Multi-level label layout 10:50 Updating the data 11:30 Conclusion ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel