Mar 26 2021 02:26 PM - edited Mar 26 2021 02:33 PM
Device and OS platform: PC/Windows 10
Excel product name and version number: Excel for Microsoft 365 MSO 16.0 64-bit
Excel file i'm working with is attached. It is unmodified and downloaded directly from the Microsoft STEM lessons page: https://www.microsoft.com/en-us/education/hackingstem/electroconductivitysensor
Serial numeric data string sent from Arduino UNO every 150ms with 3 different data, each separated by a semicolon. I am receiving the data into the worksheet but i do not know how to split them. I want to plot a live graph showing just the first data.
Here is a sample of the data recorded in the 'Data In' sheet:
0.96;-0.16;-0.12
0.51;-0.18;-0.22
0.83;-0.24;-0.27
0.49;-0.09;-0.21
But the worksheet by default only allows delimiters as comma separated values, so i don't know how to change this. I am trying to have the semicolon separated data listed into individual columns and get a live graph of the incoming data. Could someone please help?
Mar 27 2021 03:58 AM
I'm not familiar with Data Stream, perhaps this Excel and Micro:Bit - Hacking for fun and creativity! - Microsoft Tech Community helps. An option could be to use Power Query to transform data returned by Streamer, but that requires Refresh.