I would like to plot an X- Multiple Y XY Scatter plot and display the points and the Y error bars with the errorbars automatically calculated from the replicated data at each x value. I see there is a plot type for scatter plot with error bars, but this requires you to pre-calculate the error. Can this be done automatically from the data in forming the plot?
1. one X column and multiple Y columns? U can highlight all Y columns and do Statistics on Rows to get mean + sd columns to the right of data. Then highlight them to plot as scatter with error.
2. one X column and one Y columnd, with many duplicate X values in X column. Choose Analysis: Data Manipulation: Reduce by Duplicate X.... You will need to do it twice. E.g. 1st time selecting Replace Y with mean. The second time with SD for example.
Set the output SD column as YError. Use the created Mean and SD to plot scatter graph.