May 8, 2020
Charting Real Time Data in Excel
I've previously written about getting real time data (RTD) into Excel using Python. In this post I'm going to chart
Read More
January 11, 2020
Using Jitter to Avoid Over Plotting in Power BI
If you need to plot data that has one variable where values can be the same or very similar, for
Read More
May 31, 2018
Real Time Data in Excel Using Sockets
Last week I wrote about getting real time data into Excel using PyXLL and Python code. I described a way
Read More
May 24, 2018
Real Time Data in Excel
Updated April 2020 Excel does support getting real time data into the worksheet with the RTD function, but this requires
Read More
November 24, 2017
Writing UDFs in Excel With Python
My last post looked at using Python to plot equations in Excel with DataNitro. In this one I want to
Read More
November 17, 2017
Plot an Equation in Excel Using Python
Something I've wanted to do easily in Excel is plot equations. If I have something like 2x2 + 3x +
Read More