Thank you for this very helpful tutorial. Is there a way to add a reference line for each of the categories (e.g. a line that demonstrates the Average for East and the Average for West)?
Great clip, exactly what I was looking for. Although I'm trying to do this in Google Sheets. I can get it about 80% right. Anyone figured out how to do this in Google Sheets? When I split the east and west in to two separate sets of columns (as in this video), in customising the chart there is no where to enter 2s for the West data2s for the x-axis. It seems sheets only allows one set of data for the x-axis. Alternatively If I have just two columns, one with the data and the other 1 or 2 for East or West (i.e. combining the East & West data in to one set of data), then the scatter plot is separated into 2, but unfortunately East & West are considered part of the same data set and so I cannot separate East and West in the legend.
Thank you. It helped me alot. Would you also please explain how we can add SD bar and Mean to this data?
Thank you
Welcome!
Thank you for taking time to explain it! It helped me a lot!
Hi Luiza Corá, glad you liked it, thanks for commenting!
Thank you for this very helpful tutorial. Is there a way to add a reference line for each of the categories (e.g. a line that demonstrates the Average for East and the Average for West)?
The quickest way to do it is to insert a object (Insert>Text or Insert>Illustration>Shape) and type in the Avg #.
Great clip, exactly what I was looking for. Although I'm trying to do this in Google Sheets. I can get it about 80% right. Anyone figured out how to do this in Google Sheets?
When I split the east and west in to two separate sets of columns (as in this video), in customising the chart there is no where to enter 2s for the West data2s for the x-axis. It seems sheets only allows one set of data for the x-axis. Alternatively If I have just two columns, one with the data and the other 1 or 2 for East or West (i.e. combining the East & West data in to one set of data), then the scatter plot is separated into 2, but unfortunately East & West are considered part of the same data set and so I cannot separate East and West in the legend.
Hi TainuiaKid1973, thanks for the comment, don't know google sheets