Column graph with different experimental groups, fractions, needing average and error bars on Mac
Hi I'm trying to create a graph for a biology lab in which we were examine 5 different cellular fractions and finding the percentage of an enzyme present in each fraction.
For this question we were provided with this table for which we have to generate a column graph which compares the percentage of enzyme units in the different fractions. Making sure we include error bars indicating the standard deviation for each sample.
We were also provided with an example of what the graph should look like (see below). This shows the average activity for each fraction.
I am terrible at using excel and I've tried a few different ways to try get my graph similar to this.
This first attempt I know is obviously wrong. I selected all my data and created a column chart.
Attempt #2 led me here. I created this by making a smaller table with just the averages and creating a column graph from there. While this looks more accurate I can't add error bars of any kind to it so there's not much hope.
My third attempt gave me this. I pressed the switch row column button and now I can have error bars, but I can't make them error bars based off of the calculated standard deviations, so they aren't correct.
Maybe I'm being silly but I've tried to search up how to do this but I can't seem to figure it out. Most of my searches have said I need to put in custom error bars but that is not an option for me. Any help would be greatly appreciated thank you.
[link] [comments]
Want to read more?
Check out the full article on the original site