Combining scatter plot and broken line graph with the graph builder
Dec 13, 2018 5:42 AM(182 views)
Hi guys, I needs some idea for the graph builder. I got problem after making a scatter plot which has several data on the Y axis. After that I recognized I have to build in a broken line graph which has the avg data. I'm trying this by 2 methods but none works.
1. Adding a column that has the avg of the data to my data sheet and use the graph builder again -> Doesnt work because I dont know how to combine the scatter plot with the column that has every single data and the broken line graph with the column of avg data.
2. Just build the scatter plot with each data, and try to find a way to add a point that has the avg value of the points.
I have to see the min, max point of the data while following the change of the avg of the data. Does someone know a solution in this situation?