- Take sample data. Here we take 3 more columns for supporting calculation.
2. Go to the ribbon, select Insert, and select your chart type from the chart group.
3. Select Chart type as Scatter.
4. To add data in the chart, right-click on the chart and choose Select Data.
5. Select Add option to add data for creating the chart.
6. Take the first data range values as below.
7. Take the second data range values as below.
8. The chart looks like below.
9. For adding Legend – click on the Chart, press + bottom and check the Legend box.
10. After that choose Legend Position On Top.
11. For changing the Marker size, right-click on the chart to go Format Data Series then go to the Series Option, and select Marker Option, now change the marker type and size (here 22).
12. To change the first marker fill, right-click on the marker, go to Format Data Series, choose Fill, select Solid Fill, and choose white.
13. To change the first marker border, right-click on the marker, select Format Data Series then go to the border, select Solid line, and choose your color. Change the border width to 1.5.
14. To change the second marker fill, right-click on the marker to go to Format Data Series then go to the Fill, select Solid Fill and choose your color
15. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.
16. To change the Maximum Axis for Left Axis, right-click on the chart to Format Data Series then go to the Axis Option, select Maximum and reset the range.
17. To change the Minimum Axis for the bottom Axis, right-click on the chart to Format Data Series then go to the Axis Option, select Minimum and reset the range.
18. Create a formula for the Positive error bar in sample data and copy it down to cells.
19. Create a formula for the Negative error bar in sample data and copy it down to cells.
20. Create custom Data Labels through the below formula.
21. To select the error bar, click on the chart then select the + button, and check the Error bar.
22. To select No cap in the error bar, right-click on the chart to Format error bars then go to the Horizontal error bar Option, and Select No Cap.
23. After that choose Custom range from the same place.
24. Select the positive error bar and negative error bar data range from the sample data table.
25. Remove vertical error bars from the chart. Select the bar and delete.
26. The chart looks below.
27. To give the first Data Labels (here for 2018), click on the chart then select the + button, and check the Data Labels, select More Option.
28. After that select Label Option and click Value From Cell.
29. Select data range from sample data for the first data label (for 2019).
30. Unselect the Y value and change the data label position to the Left.
31. To give second Data Labels (here 2019), click on the chart then select the + button, and check the Data Labels, select More Option.
32. After that select Label Option and click Value From Cell.
33. Select data range from sample data for the second data label.
34. Unselect the Y value.
35. The chart looks like below
