The Plot Details dialog lists the error bar data under the associated plot in the left panel.
The Plot details dialog provides customization controls for error bars in both 2D and 3D graphs. The formula used for error bar calculation will appear in the Set Column Values dialog. The column includes a comment indicating the error bar type. When error bars are added to a data plot, the error data is output to a new column on the source worksheet.
This method requires the error data to be as a data column locates in the same worksheet (for worksheet data), or as a matrix object in a same matrixsheet (for matrix data). Method 3 - Using Plot Details Dialog for 3D GraphsĮrror bars also could be added in the 3D graph from existing datasets by the Plot Details dialog. Both X and Y error bars can be added by the above two methods.The above two methods are only available for the 2D plot (including polar graph) and the 3D XYY plot, but not for the 3D Surface, 3D Bars and 3D Scatter plots.Note that these two dialogs allow you to designate any worksheet column as an error bar data set regardless of the worksheet column's plotting designation or relative column position. Use the Plot Setup dialog (Origin workbook) or the Select Data for Plotting dialog (Excel workbook) to plot a data set as error bars. Choose your 2D plot (e.g., scatter, line + symbol, column/bar) or 3D XYY plot.Select both your Y data and your error bar data.(the error bar column must be to the right of the Y data column). Set up your worksheet so that the columns are designated Y1, yEr1, Y2, yEr2, Y3, yEr3.Each designated error bar dataset must be to the right of the data of the Y dataset with which it is associated (example: Y1, yEr1, Y2, yEr2, Y3, yEr3, etc). This method requires you to preset the worksheet's column Plot Designations prior to creating your plot. Using a dataset to supply error bar values Method 1 - Preset Plot Designations 2 Adding error bars to an existing graph by calculating simple dataset statistics.1.3 Method 3 - Using Plot Details Dialog for 3D Graphs.1.1 Method 1 - Preset Plot Designations.1 Using a dataset to supply error bar values.Options for controlling error bars (whiskers) in box charts are found on the Box and Lines tabs of Plot Details. User error bars in such 3D graphs as XYZ 3D scatter, matrix 3D scatter, 3D color fill surface, and 3D color map surface.Įrror bars are a standard feature of box charts and are added automatically when the box chart is created.Set style of error bars, including color, width, and transparency.Draw error bars in polar graphs as arcs.Use both X and Y error bars in column graphs.Draw error bars as lines, with fill color between error bars and data.
#HOW TO PLOT A GRAPH IN EXCEL WITH ERROR BARS HOW TO#
0 kommentar(er)
