Overlapping data points not visible on the graph

Hi sk99 

To view all markers, including identical points.
The marker should be designed differently and in a different size or shape.
Please refer to the attached images

To ensure that all your data points are visible in the chart, you can try a couple of options:

1. Adjust the marker size: You can try increasing the size of the markers for each data point in the chart. This will make it easier to see all the points, even if they overlap. To do this, select the chart, then go to the "Format" tab in the ribbon. Under "Shape Styles," you should see an option for "Marker Size." Try increasing this value until all your data points are visible.

2. Adjust the spacing: You can also try adjusting the spacing between the data points on the x-axis. This can be done by right-clicking on the chart and selecting "Select Data." From there, select the series that you want to adjust, then click on the "Edit" button next to the "Horizontal (Category) Axis Labels" box. In the "Axis Labels" dialog box, you can adjust the spacing between the data points. This may help to make all the data points visible.

3. Use a different chart type: If adjusting the marker size and spacing doesn't work, you may want to consider using a different type of chart. For example, a scatter chart may work better for your data if you have many data points that overlap. This will allow you to see all the data points more clearly.