Plotly visualization in Excel

Hello Anaconda community!

I would like to request a library to be added between 400 libraries already coming into Python excel.
This particular library is by far the best library for visualization in Python, and it is Plotly library.
Currently Plotly has massive adoption in Dash apps, but I believe that it has the biggest potential in the corporate world within the Excel viz, as it would extend Excel visualization capability by a good margin. Currently adopted libraries are Matplotlib and Seaborn which are far behind Plotly’s capabilities.

Hoping for positive response.

Regards,
Borivoj Grujicic, MBE

2 Likes

I completely agree with you. The good news: Plotly is actually already in there! The problem is that Excel can’t display Plotly’s output. We recognize the value and are working with Microsoft to find the best solution.

5 Likes

Great news! Hope for things to get resolved :pray: :writing_hand:

1 Like

Does anyone know if they are still working on this? It doesn’t appear to have been resolved yet.

I don’t have visibility into Microsoft’s roadmap, but I believe getting Python in Excel to run on other Excel platforms (Web, Mac) will happen before they tackle dynamic charts. I also don’t know how technically challenging it will be to return web content and display that in a cell.

PyXLL supports interactive Plotly chart in Excel. If Anaconda Toolbox for Excel could offer the same functionality, it would be fantastic!

Plotly - PyXLL User Guide

interactive-plotly

1 Like

It would be fantastic! Unfortunately, Excel currently only supports static images being returned from custom functions. Python in Excel has this same limitations.

Hi Jim,

Thank you for your response. It seems like the limitation is being attributed to Excel, but it’s important to note that PyXLL has successfully integrated interactive Plotly charts within Excel. This suggests that the limitation might actually lie with the current capabilities of Anaconda Toolbox rather than Excel itself. The talents within PyXLL who came up with the solution must be geniuses, and I really wish I knew how they did it.

If Anaconda could overcome this hurdle, it would empower users to create more dynamic and interactive reports directly within Excel, making Anaconda an indispensable tool for data analysts and scientists. This improvement would not only set Anaconda apart from other libraries but also tap into the vast Excel market, which is incredibly huge and full of potential. I believe this could be a game changer.

Cheers!