How can I get scatter charts to work on Dashboards?
I have numerical data in two columns on a report and I would like one column to be the x values and the other the y values on a scatter chart. There is a scatter chart option in the Chart Widget, but it only plots the x axis as a category axis, not a numerical axis. That defeats the purpose of the plot.
Of course I can make a scatter chart in Excel using the same data and then copy and paste that as an image, but is there a more elegant option? I would have to redo the scatter chart in Excel periodically because it doesn't update, as a Smartsheet chart would.