how to show if there is more than one plot in a scatter chart

[abihoughton27]

Hi,

i am trying to create a scatter chart for a risk and impact matrix - i have been able to get results to plot in the graph by my ownly issue is that i have some values that are the same - is there a way to idenitify if the plot on the graph is for more than one value?

it maybe something so obvious or you is not possible?

screenshot of the table showing an example of the same values

[v-angzheng-msft · Accepted solution]

Hi, @abihoughton27 

After my test, in the first method, you can use different colors to identify categories, because different colors at the same point will mix into new colors, so you can choose the colors with big differences.

In the second way, you can use different shapes to identify categories. Different shapes also add up at the same point, but this is easier to distinguish.

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.