google sheets
I need to draw a chart in Google Sheets that has:
Is there a way of doing this, other than, say, having a very large table of 100+ points to make sure the function is drawn smoothly?
I am happy to use a bit of JavaScript, but I obviously want a quick way of doing this with minimal code.
Using a cell_object instead of just a value worked for me
var data = google.visualization.arrayToDataTable([
[ {v: 36, f: 'Name1 - 36'}, 1],
[ {v: 22, f: 'Name2 - 22'}, 3],
[ {v: 21, f: 'Name3 - 21'}, 6],
[ {v: 4, f: 'Name4 - 4'}, 2],
[ {v: 8, f: 'Name5 - 8'}, 2]
]);
Copy of a more extreme example of 'co-linearity`:
seems to have pointed to an acceptable solution/workaround. That is, add data point markers (Point size, in Customise in Chart Editor) - in the image to one [red] data series (also with the line made thinner than the default and the other [blue] series line increased in width).
Best Answer
Two line plots with data like (x1, y1) and (x2, y2) are superimposed in a chart by arranging the data in three columns as follows:
There does not seem to be a way to smoothen only one of two lines in a chart. So yes, this means that the smooth curve will require many data points. But they can be generated with one formula, for example the following yields a plot of y = 3+2*sin(x) on the interval from 2 to 7 using the step size of 0.1 (so, 50 plot points):
Here, row(Z1:Z50) is just a way to produce numbers 1..50. These are rescaled to fit in 2..7 by the first formula, and the same is plugged into the function in the third formula. The second is a way to make an empty column in the middle, so that the data goes in two non-consecutive columns. (This would not be necessary if the smooth chart was the one with data in consecutive columns, like x1,y1 above). The resulting line chart, using the first column as labels:
The blue line comes from numeric data (below), placed above that arrayformula.