I enter the data into excel as I am performing the experiment and my final goal is to show the results like the chart shown below, which is created in GraphPad:
Bar & Scatter.png
I know it's difficult to make this in Excel but I am wondering if it is possible to make something similar? e.g., make separate charts like like like showing below, so that I can see the variability of each group as my experiment progress (I can make additional bar graphs to see the means):
Scatter plots.png
Below is the example of my data table
Subject Group Measurement
1 control 768
2 Treatment-1 334
3 control 307
4 treatment-2 4840
5 treatment-1 5150
6 Treatment-2 8710
7 control 10500
8 treatment-1 6970
Thanks a lot in advance!
Bookmarks