Overlapping data points not visible on the graph

[sk99]

Hi everyone, 

I am trying to make a line chart with markers. I have three different lines showing three different series of data. 

For a particular value in the x-axis, two of my series have the same data point for the y-axis. So what happens is only one data point shows up. The other one does not show up even after hovering over that point. 

Need some help with understanding how to ensure all my datapoints are visible in the chart.

Thank you!

[Ritaf1983 · Accepted solution]

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Adamboer · Accepted solution]

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.

[Ritaf1983 · Accepted solution]

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.