I have data points that are the averages of several individual pieces of data. I want to display the mean value with positive and negative standard deviation that describe the numbers that make up that mean. There are a total of five of these mean values that I need to show.
I've attached both an Excel file with the data, and a .jpg file that I generated with SigmaPlot showing how it should look. Each error bar is individual to the bar that it's associated with (values in the Excel file).
Does anyone know how to enter individual standard deviation values for each data point in Excel 2007? I could just use SigmaPlot to do all of the graphs, but that program is much slower to use, and the graphs are very ugly; since I need many of these graphs for a presentation, it's important that they look uniform and nice.
Thanks so much in advance.
Bookmarks