What is Data Streamer?
Use PASCO Data Streamer to collect data with PASCO Wireless Sensors and stream the data into an Excel workbook.
Installation and Setup
To stream data from PASCO Wireless Sensors to Excel, you need to install PASCO Data Streamer and enable the Excel Data Streamer add‑in.
Overview of the Excel Workbook
After connecting PASCO Data Streamer to Excel, Excel displays four customized spreadsheets by default. The two sheets used with PASCO sensors are the Data In and Settings sheets.
Using Data Streamer
Use Data Streamer to stream data from sensors, record the data, and visualize the data in different displays.
- Stream Data
  To stream data, connect a sensor to the PASCO Data Streamer app, then connect the app to Excel.
- Display Data
  Visualize data in a variety of ways including a graph, bar chart, and digital meter.
  - Display Data in a Graph
    Visualize streaming data as a graph using a scatter chart in Excel.
  - Display Data in a Bar Chart
    Visualize streaming data using a 2-D Column Chart in Excel.
  - Display Data in a Digital Meter
    Visualize a single measurement by creating a dynamic text box in Excel.
  - Min and Max Axis Values
    The maximum and minimum axis values on a chart change automatically by default, which can sometimes make data difficult to view. You can fix this by setting static minimum and maximum axis values.
- Manually Sample Data
  Manually record data points instead of continuously streaming data. This method is useful for displaying a sensor measurement versus a non-sensor measurement.
- Record and Replay Data
  Record data to a .csv file to replay data at a later time.
- Calibrating sensors
  If sensors are not measuring values as expected, you may need to calibrate the sensor.
- Sample Workbook Files
  Learn how to use the sample workbook files provided on the Data Streamer page on the PASCO website.

Display Data in a Graph

Visualize streaming data as a graph using a scatter chart in Excel.

On the Data In sheet, click any cell in the Historical Data table.
Go to the Insert ribbon and select any Scatter chart.

Excel selects all the Historical Data.
Drag the sizing handles to select the data to display in the chart.
Go to the Data Streamer ribbon and click Start Data .

Tip: Display additional data points on the graph by changing the number of Data rows on the Settings sheet.

Note: Cut and paste the chart to Sheet 1 or create a new sheet. The chart won't remain on the Data In sheet if you make any changes to the Data Streamer settings or reconnect PASCO Data Streamer to Excel.