How to use error bars to create a ladder diagram in Excel

php editor Youzi introduced how to use error bars to create ladder diagrams in Excel. In Excel, by setting the parameters of the data series and error bars, you can easily create a chart with a trapezoidal shape, adding new visual effects to data analysis and presentation. Following the editor's guidance, you can quickly learn how to use the error bar function to create a ladder diagram in Excel, improving the expressiveness and professionalism of data charts.

1. Select data area A1:B13 and insert a scatter plot.

2. Adjust the scale of the Go to cell E1 and set the cell format to normal to get 42005. Enter the formula =E1 11*31 in cell E2 to get 42346.

3. Double-click the X-axis to bring up the settings dialog box. Fill in the two numbers obtained in the previous step in the minimum value and maximum value, and enter Add a custom format mmm to the tab and close the dialog box when finished.

4. To customize error bars, first add two sets of auxiliary columns. Make Y negative deviation in column C, make X negative deviation in column D, and enter a fixed value in C2. 0, enter the formula in C3: =B3-B2, fill down to C13, enter a fixed value -30 in D13, enter the formula in D2: =-(A3-A2), fill down to D12.

5. Select the chart and select [Error Bars] - [Standard Error Error Bars] on the [Layout] tab. At this time, you can find it in the drop-down box on the far left The X and Y error bars are out.

6. Select X error bar in the drop-down box, select [Error Bar] - [Other Error Bar Options], and select [Wireless End] in [End Style] Then select [Custom]-[Specify Value], enter 0 for the positive error value, and enter: =Sheet1 for the negative error value! $D$2:$D$13, confirmed after completion.

7. In the same way, select the Y error bar in the drop-down box, select [Error Bar]-[Other Error Bar Options], and click [End Style] 】Select [Wireless Terminal], then select [Custom]-[Specify Value], enter 0 for the positive error value, and enter 0 for the negative error value: =Sheet1! $C$2:$C$13, confirm after completion, the effect is as shown below.

8. Because the prices remain above 5, we only display the scale above 5 to expand the difference in the graph. Double-click the Y-axis, enter 5 for the minimum value, and confirm .

9. Make appropriate beautification of the chart. The final effect is as shown in the figure

Note:

Because of the nature of the date Above is a numerical value, so you can use it to make a scatter plot

The above is the detailed content of How to use error bars to create a ladder diagram in Excel. For more information, please follow other related articles on the PHP Chinese website!