Hi.
I'm making tables and charts for steel's corrosion weight loss for few samples. I don't know how to select data for the Error Bar for my data.
Quick overview of the file:
- Sheet - "Weight": Input weights of steel samples.
- Sheet - "D-Weight": Calculating the Delta-Weight. I.e. the weight loss since beginning.
- Sheet - "P-Weight": Calculating the weigh loss percentage. I.e. the weight loss since beginning.
- Sheet - "Ave-Stdev": Calculating average of weight loss for each subgroup and standard deviation.
Extra info for deeper understanding of the file.
40 samples total. Marked X.Y.Z
- X = Group (1,2)
- Y = Subgroup (1,2,3,4,5)
- Z = Sample Numbers (1,2,3,4)
What I'm trying to do is: Make scatter plot with the results in "Sheet-Stdev" with error bar. I don't know how to select row for the error bar for each group/subgroup.
Here is the .xlsx file - Hope someone can help me. mælingar.xlsx
Thanks, in advance.
Bjartmar
Bookmarks