The protocols for adding custom error bars differ between Classic Excel and new Excel. The chart itself is easy: create an XY chart using the data in columns A and B. The error bars are also drawn using all the error bar data at once: C2:C6 and D2:D6 for horizontal and E2:E6 and F2:F6 for vertical. The series is plotted using all the data at once, with X in A2:A6 and Y in B2:6. The data is set up so that, for example, cells C2 and D2 have the values for the positive and negative horizontal (X) error bars for the point defined by X and Y values in A2 and B2. Cells E2 and F2 have the values for the positive and negative vertical (Y) error bars for this point.
SIGMAPLOT 11 ASYMMETRIC ERROR BARS PLUS
Suppose we have the following data: X and Y values, plus extra columns with positive and negative error bar values for both X and Y directions. I usually put these values in the same table as the actual X and Y values Manually Defining Custom Error Bars Sample Data and Charts You need to put all of the individual error bar values into a range of the worksheet. However, you can individual custom error bar values to all points in a plotted series. You cannot add custom error bar values to a single point in a chart. Both articles contained instructions for adding custom error bar values for individual points, but judging from the emails I receive, a separate article on custom error bars is needed. I’ve written about Excel chart error bars in Error Bars in Excel Charts for Classic Excel and in Error Bars in Excel 2007 Charts for New Excel.