how to plot a graph in excel with error bars

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.Specify how to skip error bars when drawing.Set style of error bars, including color, line width, cap width, and transparency.Origin provides customization controls for error bars in both 2D and 3D graphs. Origin can draw error bars on a graph to indicate error or uncertainty in a reported measurement. See more related video: Adding Error Bars to a Graph

How to plot a graph in excel with error bars