![Custom Error Bars Excel 2016 Custom Error Bars Excel 2016](/uploads/1/2/5/4/125458511/488209513.png)
Feb 29, 2016 This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. Error Bars 1. Select the chart. Click the + button on the right side of the chart, click the arrow next to Error Bars and then click More Options. Choose a Direction. Choose an End Style. Click Fixed value and enter the value 10.
I am busy writing a thesis and am plotting some data using the clustered column graph. I have 5 values on the X-axis (time in days.0-4), and for each of these X-axis values (days) I have 3 Y-values (high, medium, low dose observations). The problem is that each Y-axis value is a mean, and has a unique standard error of the mean (SEM). However, I can't find a way to make unique error bars for each data point. Instead, it will only allow me to enter 1 custom error bar value per dose observation over time.
![Custom error bars excel 2016 review Custom error bars excel 2016 review](/uploads/1/2/5/4/125458511/768703331.png)
I feel like this is doable, but I just can't figure it out. Perhaps I just need to use another graph format? I feel like there is something really obvious that I am missing. I don't know if this is clear, but was wondering if anyone can help. I really don't want to have to draw these error bars in using powerpoint. I can elaborate if need be.
Thanks in advance!