Using Excel, and PLX-DAQ to live steam data from a microbit.
It is possible to chart data from the microbit in Excel in real time. However, it’s important to note Excel was never designed for this and has some limitation.
Parallax Data Acquisition Tool (PLX-DAQ) is used to acquire the data which is then charted in Excel.
In this example, the value of the x, y & z axis of the accelerometer is plotted in a chart.
Download and install PLX-DAQ
PLX-DAQ folder on your desktop.
PLX-DAQ spreadsheet file.
This script runs on the microbit and sends the accelerometer readings over a serial connection.
Select ports and baud speed (115200; not 9600) and click ‘Connect’.
Press the ‘reset’ button on the back of the microbit. Data from the microbit will stream into the spreadsheet. Charts can be drawn which are updated in real-time.
Published: December 23, 2016 Updated: December 23, 2016