Microsoft said it couldn't be done - Interactive Python Charts in Excel
Рет қаралды 45,406
Күн бұрынHow to build interactive Python charts in Excel using Slicers to control interactivity and connected to data in Power Query.
With this trick we can use Slicers to control both Python charts and Excel charts at the same time. Suitable for Excel dashboards and more.
⬇️DOWNLOAD the Excel & CSV files here: www.myonlinetraininghub.com/i...
📝 Note: Python in Excel is currently available to Microsoft 365 Office Insider users on the Beta Channel: insider.microsoft365.com/join
PQ Learn Power Query: www.myonlinetraininghub.com/e...
❓ Will you be using Python Charts in Excel? Please let me know in the COMMENTS.
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 CONNECT with me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Interactive Python Charts in Excel
0:28 Connect Python in Excel to Power Pivot
2:18 Create Python Dataframe
4:11 Setting up the Slicer
5:17 Capturing Selections in Slicer
6:33 Filtering the dataframe with Slicer
7:43 Creating the Python Chart in Excel
10:27 Create Pivot Chart Connected to Slicer
12:50 Limitations
@tecwzrd 11 ай бұрын
It's probably going to take 2 years for my work 365 license to update to include PY but so looking forward to more advanced charting capabilities. Saving all of these for future reference. I always love when you find a workaround for something MS tells you that it can't be done :)
@MyOnlineTrainingHub 11 ай бұрын
Wow, that's a long time! Glad you're looking forward to it though.
@dalskiBo 11 ай бұрын
Yes I'm disappointed my build version (same as video) does not include it also.
@ajarivas72 11 ай бұрын
Buy your own license.
@tecwzrd 11 ай бұрын
@@ajarivas72 I've been using Spreadsheet programs for 40+ years. I code in VBA, Python, C++, Java, and 8 other computer languages. I started wtih VisiCalc, then Lotus 1-2-3, and finally Excel. I've had a home licence for everything, and am part of the 365 Insider program and 365 Developer Program. The problem is that the file I create at home can't be used at work, which is where it's most needed. My work is very security sensitive which is why it takes so long to roll out updates.
@LuisCarlosChavez717 11 ай бұрын
Awesome as always! Please do more videos about Python and Excel in the future.
@MyOnlineTrainingHub 11 ай бұрын
Thanks, will do!
@sonang4154 11 ай бұрын
Extraordinary tutorial as always Mynda! Can’t tell how much I have learnt from you. Please keep up the good work!!
@MyOnlineTrainingHub 11 ай бұрын
You're too kind! Thanks so much! 😊
@pravinshingadia7337 11 ай бұрын
Your videos are awesome. Thanks for keeping them short and to the point and not dragging out.
@MyOnlineTrainingHub 11 ай бұрын
Glad you like them! 🙏😊
@jozonas 11 ай бұрын
First video I've watched from you and it has been enough to subscribe before seeing what else you got there. your thought process and attitude was enough to convince me. Thanks for sharing! Gonna dive into your other videos now. :)
@MyOnlineTrainingHub 11 ай бұрын
Awesome! Thank you!
@mohanreddyk1983 11 ай бұрын
Hi Mynda, You really GENIUS to use Excel app. I am following you from 2013 and learnt a lot. Those really helped me to implement in my work. Waiting for Python in Excel to enable in my Office 365 subscription. Hoping for more videos from you on Python in Excel in future. Thanks a million 🤝
@MyOnlineTrainingHub 11 ай бұрын
Wow, that's wonderful to hear 🙏😊
@YouExcelTutorials 11 ай бұрын
Amazing! Well delivered and super useful. Hoping to get this feature in the next update🤞🏽 Thanks for sharing, Mynda!
@MyOnlineTrainingHub 11 ай бұрын
Thank you! 🤞for the next update for you!
@ExcelHechoFacil 11 ай бұрын
Gracias Mynda por este gran aporte! Me encantan tus videos.
@MyOnlineTrainingHub 11 ай бұрын
Thanks for watching!
@huubpoppelaars7597 11 ай бұрын
Mynda, I am you following as a retiree with a lot of Excel knowledge, but following your videos is a pleasure and a good way to keep up with all new features. I can not wait to have also PY in my version of Office.
@MyOnlineTrainingHub 11 ай бұрын
Wonderful to hear! 🙏😊
@JuanCarlosGonzalezCuevas 11 ай бұрын
I'm really impress. Thank you very much for share your knowledge. I use a lot Power Query and Power Pivot in Excel. You have a new subscriber from Chile!
@MyOnlineTrainingHub 11 ай бұрын
Awesome! Thank you 😊
@rrrprogram8667 11 ай бұрын
Excellent video.... Thanks for sharing.... We need more of such videos
@MyOnlineTrainingHub 11 ай бұрын
Thank you! Working on it 😉
@FredericLEGUEN-Excel 11 ай бұрын
Impressive job Mynda. You cover so many aspects of Excel and Python in this video. Congrats
@MyOnlineTrainingHub 11 ай бұрын
Thanks so much, Frederic! 😊
@cedjulemckeever 11 ай бұрын
Interesting video. Way beyond my skill level. I'm still trying to understand formulas and Power Query. Mr. Excel gave you praise on your other videos. Keep up the good work.
@MyOnlineTrainingHub 11 ай бұрын
Thank you! TBH, it's beyond my skill level too, but ChatGPT helps a lot!
@cedjulemckeever 11 ай бұрын
Don't know if you would be interested but there is a course on AI and Python on KZfaq. kzfaq.info/get/bejne/a7SXgcyUprTdoYE.html
@MlguelM 11 ай бұрын
Thanks a lot Mynda! Very usefull content as always!😊
@MyOnlineTrainingHub 11 ай бұрын
Glad you think so!
@JennTheWriter 11 ай бұрын
Love this stuff! So fun! Thank you! :)
@MyOnlineTrainingHub 11 ай бұрын
🙏 Glad you enjoyed it!
@stevenstern1155 11 ай бұрын
Wow!! Python now in Excel. Can't wait to see new videos. Thanks
@MyOnlineTrainingHub 11 ай бұрын
More to come!
@HandelMcHandel 11 ай бұрын
Still waiting for Python - got an update yesterday but still not active - but still enjoying your Videos - will catch up eventually. They really are awesome -well done!
@MyOnlineTrainingHub 11 ай бұрын
Thanks so much! Fingers crossed you get it soon. Be sure to check other PCs/laptops to see if they get the update. It's not specific to your login, but rather the installation of the software on each device.
@martins8587 11 ай бұрын
Looks fascinating. Great video. Very evident that you've already deepened your understanding significantly from your first XL Python video. Loving your output. ☺ For me, there are two irritants. 1. I'm on the Insider Programme, but not the Beta Channel. So I can't play around with it yet. 2. Given that we don't know how much of the new functionality is going to be placed behind a paywall (thanks Microsoft!), it could prove to be an anti-climax. I remember that you said once that you and other MVPs lobbied Microsoft NOT to paywall Power Query/Power Pivot and won. Fancy picking up the challenge a second time Mynda?? We're rooting for you! 🥊
@MyOnlineTrainingHub 11 ай бұрын
We're already fighting 😉
@hoof-hearted-2024 11 ай бұрын
Noice! Jaw on floor with my tongue rolled out 😂 It's nice to finally see some original content, seems Excel channels these days are simply copying each other. Well done, Miranda! 👍🏽
@MyOnlineTrainingHub 11 ай бұрын
Wow, thanks! 😊
@chrism9037 11 ай бұрын
So cool! Thanks Mynda
@MyOnlineTrainingHub 11 ай бұрын
Thanks for watching, Chris!
@rachelle5432 11 ай бұрын
Very useful! Hope to get more amazing updates and tips
@MyOnlineTrainingHub 11 ай бұрын
More to come!
@garydunken7934 11 ай бұрын
Excellent! Py in Excel will open up so many things for me. Can't wait to get Py working on the beta channel that I signed up yesterday.
@keylanoslokj1806 11 ай бұрын
It will also introduce many new vulnerabilities though and bugs to fix
@MyOnlineTrainingHub 11 ай бұрын
@garydunken7934 Great to hear! @keylanoslokj1806 that's all part of the development phase, which is why they release it slowly to segments of the beta channel. Not sure I agree that it'll result in new vulnerabilities though 🤔
@consultcorpgroup1231 11 ай бұрын
Magnificent 👍🏻 Great steps to continue my improvement. Thanks for your excellent effort to motivate us 👍🏻
@MyOnlineTrainingHub 11 ай бұрын
My pleasure 😊 Have fun with it!
@flexyourdata 11 ай бұрын
Brilliant. Well done!
@MyOnlineTrainingHub 11 ай бұрын
Thanks so much!
@LucaMelfi 11 ай бұрын
Awesome tutorial!
@MyOnlineTrainingHub 11 ай бұрын
Glad you liked it!
@heikoheimrath7514 10 ай бұрын
Great video Mynda - very interesting
@MyOnlineTrainingHub 10 ай бұрын
Glad you enjoyed it, Heiko!
@MegaTrickykid 11 ай бұрын
fantastic! Thank you very much indeed!
@MyOnlineTrainingHub 11 ай бұрын
Glad you liked it!
@ExcelHechoFacil 11 ай бұрын
I loved the use of: dropna, tolist, isin in pandas. Sorry, my English is not good, I use google translate. Thank you very much for your great contributions.
@MyOnlineTrainingHub 11 ай бұрын
Glad you liked it!
@bluetaurean 11 ай бұрын
Your content is amazing.
@MyOnlineTrainingHub 11 ай бұрын
Glad you think so! 🙏
@Ugk871 11 ай бұрын
This is awesome. Thanks
@MyOnlineTrainingHub 11 ай бұрын
Glad you liked it!
@pakipower 11 ай бұрын
wow...just wow Mynda 👍 excellent.
@MyOnlineTrainingHub 11 ай бұрын
Thank you so much! 😊
@kyawsoemoe.u2140 11 ай бұрын
Thanks for sharing
@MyOnlineTrainingHub 11 ай бұрын
Thanks for watching!
@mohammed_Ansar 11 ай бұрын
Excellent ❤
@MyOnlineTrainingHub 11 ай бұрын
Glad you like it!
@andaydeniz 11 ай бұрын
You are amazing 🎉
@MyOnlineTrainingHub 11 ай бұрын
Thanks so much!
@Muuip 11 ай бұрын
Thanks! Looking forward to it! Excel + Python + Pandas 👍
@MyOnlineTrainingHub 11 ай бұрын
Great to hear!
@Muuip 11 ай бұрын
@@MyOnlineTrainingHub Might solve challenges I encountered creating a clinical biomarker platform, like a formula for APACHE score used in ICU. Hoping to see tutorials on medical applications in the future. I'd be glad to share what I got sofar.
@korysnyi_excel 11 ай бұрын
Awesome! So we can use both pivot charts from Excel and pivot charts from PY at the same time.
@MyOnlineTrainingHub 11 ай бұрын
Yes, absolutely 😁
@snipelite94 11 ай бұрын
Awesome! 😊 📊📉📈💹
@MyOnlineTrainingHub 11 ай бұрын
😊🙏
@johnborg5419 9 ай бұрын
Thanks Mynda. Some of it is Greek to me for now. :) :)
@MyOnlineTrainingHub 9 ай бұрын
😊me too, John!
@ivanbork4175 11 ай бұрын
Hi Mynda Very interesting, unfortunately I have not Python on my 365 yet, and when the time comes it will be great if you have a full course about the subject, since I must start from scratch. Best regards
@MyOnlineTrainingHub 11 ай бұрын
Cheers, Ivan!
@barttitulaerexcelbart9400 11 ай бұрын
So great to see examples of what you can do with it. Unfortunately I have to wait two months at least to start practicing. Future question: you make dynamic charts, for example in the title of a graph referencing to a cell. In Pivot/Excel you can do so to refer to the page field. But if you have multiple selections, you can not refer any more ("multiple fields"). Maybe Python can??
@MyOnlineTrainingHub 11 ай бұрын
Great to hear you're excited to use Python in Excel, Bart! Yes, I'm sure Python can display multiple selections in the title. You can also do it with Excel using the TEXTJOIN function: www.myonlinetraininghub.com/excel-textjoin-function
@GoodLife-ru8di 11 ай бұрын
Awesome tutorial. Have you tried using plotly instead of seaborn? I guess you can make the charts interactive with plotly.
@MyOnlineTrainingHub 11 ай бұрын
You can't use any Python interactive charts by Plotly, Seaborn, Matplotlib.... yet.
@MeroslavTsaakoff 11 ай бұрын
Hi! There are two statistical algorithms which are good for our favorite excel... I) for any time when is the most profit and II) in any time, when is the worst profit... !
@MyOnlineTrainingHub 11 ай бұрын
😁
@EddieK4524 11 ай бұрын
Awesome tutorials for me as a beginner. A bit too fast though. But very useful 😊
@MyOnlineTrainingHub 11 ай бұрын
Glad you liked it! Use the cog icon to change playback speed to slower.
@EddieK4524 11 ай бұрын
@@MyOnlineTrainingHub I have always liked your videos. Your tutorials are very informative and easy to understand
@GuyOrlov 11 ай бұрын
blow my mind away I hope R Script will be integration after this.
@MyOnlineTrainingHub 11 ай бұрын
Who knows what’s next 😁
@tahirshah6979 11 ай бұрын
I am also waiting for R in Excel.
@roywilson9580 11 ай бұрын
Nice work-around. It is great that Excel has the ability to use the extended range of charts available in the Python packages but wouldn't it be easier to just build the full report in python and display it in a browser window? There are some pretty neat Python packages out there that allow you to do just that.
@MyOnlineTrainingHub 11 ай бұрын
Sure, if you know Python. I find getting nicely formatted charts easier in Excel. The Python chart labels, legends, borders etc. are ugly and require coding to change them. Excel chart tools are point and click, so for Excel users who don't have Python skills and who need a chart that's already natively in Excel, it's easier to use them.
@roywilson9580 11 ай бұрын
@@MyOnlineTrainingHub yes I totally agree, but would say that anyone who can manage Excel formulae and Power Query M or DAX for Power Pivot would not have a huge learning curve to start to obtain some pretty spectacular results, especially if using some of the amazing packages available to do a lot of the heavy lifting for you. I am finding that, even as a relative newcomer to python, using python and it's associated libraries is pretty intuitive. The hardest part of the process was getting set up, and even that was not overly difficult to work out with a little patience. That said, Excel will always have a special place in heart and I will get excited about every new development that refines the way it handles data. I look forward seeing more of your videos dealing with this topic in the future and getting to use this amazing new feature. It seems that though I have it there is a bug in my implementation that stops excel from recognising the =PY function along with several other people I can't wait for MS to iron this out!
@brianvaddan9987 11 ай бұрын
Wow that is amazing. So am I correct in understanding that we now have access the power queries data size benefits, the ability to use the excel formula bar as a Jupyter Notebook, access all python libraries and visual the output in excel? So excel really has the benefit of a Large Data engine?
@MyOnlineTrainingHub 11 ай бұрын
Yes, kind of! Not 'all' libraries. Only those supported by Anaconda. Yes, big data via Power Query but currently limited to 100MB while in testing/beta mode.
@Jakeu1701 11 ай бұрын
Interesting. Would it be possible to create a word cloud based on several rows of customer comments?
@MyOnlineTrainingHub 11 ай бұрын
I expect so, yes. You can use Python to extract sentiment, or keywords and then plot it in a word cloud.
@patriciorios3474 11 ай бұрын
When this feature will be available for all users?
@MyOnlineTrainingHub 11 ай бұрын
It will depend how it goes in the beta channel as to how quickly it becomes generally available. My guess is it's at least months away.
@spilledgraphics 11 ай бұрын
buckle up for this one people! 😵😵😵😵
@MyOnlineTrainingHub 11 ай бұрын
😁
@spilledgraphics 11 ай бұрын
@@MyOnlineTrainingHub just finished up watching thoroughly Mynda, amazing stuff !thank you!
@guranslifes 11 ай бұрын
plotly library supports interactive mode. please try it
@MyOnlineTrainingHub 11 ай бұрын
But not inside of Excel. The interactive Python charts do not work in Excel, unfortunately.
@edmundchan8923 11 ай бұрын
Do you know if we can incorporate python chart in powerpoint?
@MyOnlineTrainingHub 11 ай бұрын
Yes, use the linked picture, or embed the Excel file: kzfaq.info/get/bejne/jc2gmcyHrNmaoZc.html
@CaribouDataScience 10 ай бұрын
Is Excel using Anaconda (cloud)?
@MyOnlineTrainingHub 10 ай бұрын
Yes. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. 😊 More here: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
@CaribouDataScience 10 ай бұрын
@@MyOnlineTrainingHub interesting.
@steven.h0629 11 ай бұрын
👍😎✊
@MyOnlineTrainingHub 11 ай бұрын
🙏😊
@CaribouDataScience 11 ай бұрын
I signed up for Excell Insider but am still not see Python?
@MyOnlineTrainingHub 11 ай бұрын
New features are released to batches of Beta users to ensure things run smoothly. If you don't see Python yet, check daily for updates. You might be lucky and be in the next batch!
@CassidyListon 11 ай бұрын
Hey. I can't get the right version of Excel installed. I opted into the Insider Program via the Account settings. I installed the latest update. It still doesn't work. Really frustrating!
@MyOnlineTrainingHub 11 ай бұрын
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
@ggneb2126 11 ай бұрын
MSFT is a frustration as always. I signed up for Beta channel in Insider program. Nothing shows up in my Excel 365.
@MyOnlineTrainingHub 11 ай бұрын
The insider program releases new features to segments of users to test. As the weeks go by, more and more users on the beta channel will get the feature. Hopefully you'll get it in next week's update. 🤞
@xxczerxx 11 ай бұрын
Can you use Python to dynamically add rows? If you can use Python to manipulate actual objects (sheets, cols, rows) that is awesome. You can get VBA to do this but the language is pretty horrible imo.
@MyOnlineTrainingHub 11 ай бұрын
Yes! You can use Python for data cleaning and manipulation.
@DanielADamico 11 ай бұрын
Microsoft mentioned that certain Python in Excel features will require payment once they are generally available. It's unfortunate news. 😔
@MyOnlineTrainingHub 11 ай бұрын
Yes. I can see both sides. 😞
@gavinsmith9564 11 ай бұрын
No python yet on my Beta channel 😞
@MyOnlineTrainingHub 11 ай бұрын
Check for updates daily. More and more people will get it in the coming weeks.
@gavinsmith9564 11 ай бұрын
@@MyOnlineTrainingHub I'm checking almost every minute :-)
@mohamedtalaat5836 11 ай бұрын
It is great, but still I'm don't have Python on my excel 365
@MyOnlineTrainingHub 11 ай бұрын
It's slowly being rolled out to office insiders on the beta channel. Maybe with next week's update 🤞
@sukivirus 11 ай бұрын
Microsoft should have provided a library for Python and C++ developers to interact with excel. Python in a cell does not look promising.
@MyOnlineTrainingHub 11 ай бұрын
You can bring in more libraries. There are several loaded by default e.g. Pandas, Seaborn, Matplotlip etc.
@sukivirus 11 ай бұрын
@@MyOnlineTrainingHub I agree with you. But if I create a class in python script file and want to import that into excel. Is it possible to create object of that class ?
MyOnlineTrainingHub
Рет қаралды 66 М.
MyOnlineTrainingHub
Рет қаралды 120 М.