error bars
2 TopicsError bars do not work with custom values - multiple series chart
I have a bar which has multiple series. Think of it as a number charts combined together. I created a table which has the 8 series to be plotted. For each series has a std deviation for each value. Every value is an average of a sample population and as such has a std deviation which I want to plot using error bar options of Excel. The bug i'm facing is that thee first series takes (plots) the custom error values while all other series show nothing. I tried the view/paint options of the error bars but that did not help. I'm convinced the problem is either a bug or some issue with data "reading" . I have attached the excel. The first tab "results Graph 03" has the bars I'm talking about. The first graph is column chart labeled "Sorptivity summary of 3 months specimens grouped by mixture design".In that graph there are the 8 series plotted in it. Labeled in the table columns as A,B,C,D with post-fix H and F each. For each series i added in Column O a bunch of value which are the standard deviations representing the errors. I do not need or want to use the std deviation or other features provided by MSFT error bar options. I want to use those custom values as both the plus and the minus ones. Steps i use 1> Add chart elements > Error options 2> I choose the series 3> for the series i choose "Custom" as the error amount and specifiy the + and -ve as the std deviation in column O. Nothing happens except for first series A-HSolved21KViews0likes5CommentsError bars basic question
Hello all. That seems a basic question but it is confusing me. I submitted a paper to journal with chart. This chart represents the results of experimental work. The reviewer asked me to add error bars to the figure, and when I did , it seems to have no meaning since the results are not trials, the data is one column for x and one column for y. I'm I missing something I should process in excel before adding the error bars? I attached the chart and data. x y 0 85 0.5 61 1 48 1.5 38 2 13Solved1.7KViews0likes3Comments