Error updating a list item unknown error
(If the chart has more than one series, and you had not specifically selected one series, there is an intermediate dialog asking which series to work with.) This dialog doesn’t look too unfamiliar.But there is no obvious way to switch to the horizontal error bars.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.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.The chart itself is easy: create an XY chart using the data in columns A and B.
This chart shows just the Y error bars, to show clearly that each point has custom values different from other points: This chart shows the X and Y error bars: A single custom error bar value cannot be added to a single data point, and custom error bar values cannot be added to a series of data points one point at a time.
The series is plotted using all the data at once, with X in A2: A6 and Y in B2:6.
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.
There is no convenient tab on the Format Series dialog.
The Error Bar tab(s) as well as the tabs for Data Label, Up/Down Bars, High/Low Lines, and other features have been removed to make them more discoverable, at least that’s what we were told.