Oh, plotly is an awesome online graphing tool. You can enter data and plots manually or have data sent from python. You should check it out. Ok - back to heatmaps.

Open Excel, and you will see a new tab in the ribbon at the top that says PyXLL.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.