Start Open office charts not updating

Open office charts not updating

The chart itself is easy: create an XY chart using the data in columns A and B.

Put your custom values into a range parallel to your X and Y values as I’ve done with this sample data, then use the manual technique or the utility to add all the values to the chart series in one step.

It is harder to apply error bars in Excel 2007 than in earlier versions.

Move the dialog so it does not cover the range containing your custom values, then click on the Custom option button, and click on Specify Value.

A small child dialog appears with entry boxes for selection of the custom error bar values.

You cannot add custom error bar values to a single point in a chart.

However, you can individual custom error bar values to all points in a plotted series.

Bring up the Format Series dialog, by double clicking on the series, by right clicking on the series and choosing Selected Object, by selecting the series and choosing Selected Data Series from the Format menu, or by selecting the series and clicking the shortcut, Ctrl 1 (numeral one).

The dialog has a tab for Y Error Bars, and if it’s an XY data series, there is also a tab for X error bars.

Finally, select the More Error Bars Options at the bottom of the list.

X (if it’s an XY chart) and Y error bars with initial constant values of 1 are added to the chart series, with the Y error bars selected, and the Format Error Bars dialog is displayed with the Vertical Error Bars tab showing.

Click on the horizontal error bars to change the dialog.