Error validating the formula speed dating maui
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.
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.
The protocols for adding custom error bars differ between Classic Excel and new Excel.
To define custom error bars, click in the or – data entry box (no need to select the Custom option button, Classic Excel does this automatically), then select the range containing the custom error bar values using your mouse.
If you need only one value for all of the points, you can select a single cell, or even type the value you want.
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.
Search for error validating the formula:
The edit box is so narrow, that you cannot see the entire expression at once, and it will be difficult to find this error. Don’t completely clear an entry box, because Excel will think you simply forgot and it will retain the previous value.