how to plot a graph in excel with error bars

In the new window that appears, choose =Sheet1!$C$2:$C$5 for both the positive error value and negative error value. In the window that appears to the right, click the Custom button at the bottom. To add confidence interval bands, click the plus sign (+) in the top right corner of the bar chart, then click Error Bars, then More Options: This will produce the following bar chart:

Then click Insert Column or Bar Chart within the Charts group. To create a bar chart to visualize the category means, highlight cells in the range A1:B5 and then click the Insert tab along the top ribbon. Suppose we have the following data in Excel that shows the mean of four different categories along with the corresponding margin of error for the 95% confidence intervals: Example 1: Plot Confidence Intervals on Bar Graph This tutorial explains how to plot confidence intervals on bar charts in Excel. Theme( confidence interval represents a range of values that is likely to contain some population parameter with a certain level of confidence. Geom_polygon(aes(y = lower), fill = 'grey99', alpha = 0.7) + Geom_polygon(aes(y = upper), fill = 'grey50', alpha = 0.5) + Geom_segment(aes(xend = variable, y = lower, yend = upper), colour = 'grey50') + Geom_polygon(fill = NA, colour = 'purple') + Scale_linetype_manual(values = c(2,1,2)) + Scale_colour_manual(values = c('steelblue', 'black', 'steelblue')) + Ggplot(aes(x = variable, y = value, colour = measure, group = measure, linetype = measure)) + Gather(measure, value, -variable, -stderr) %>% Geom_ribbon(aes(ymin = lower, ymax = upper), fill = 'grey50', alpha = 0.5) + Ggplot(aes(x = variable, y = midpoint, group = 1)) + Mutate(variable = factor(variable, levels = variable)) I like the look of my option 1 best, but I'm not sure how to solve the gap between var32 and var1 (I have some ideas, but a bit awkward). I don't much like radar charts but here are some ideas to get you going, drawing on this approach.

How to plot a graph in excel with error bars