Question on graphing data on a dashboard while using a smartsheet form

Jared P

Hello,

I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I select and won't continue down the sheet with new submissions.

Current Issues:

1. The smartsheet uses automation. As soon as a cell is changed the sheet automatically adds in upper/lower limit and targets, which also get plotted.
2. The main problem is that I can only plot the data that currently exists and the dashboard won't plot new entries as they added to the smartsheet. In the screen shot my data is being plotted down to row 5, but won't plot row 6 that was added without manually making the chart plot row 6.
   Capture.PNG

What is the best way to solve this and allow my chart to plot any new data point that shows up in the column?