Forum Discussion
Scatter chart same x-axis value data points got overlapped
Hi, I've got this scatter plot. What I'm trying to achieve is to show the performance % by ID (ie., Franchisee) and apply colour conditional formatting using the Region info. No y-axis in my case (see my visual setting on the right).
However, there are many ID's that are having the same x-axis data points and I couldn't figure out how to show them all in the chart. Below is what I want to achieve (see the red dots):
I'm open to alternative visuals so if you have any better ideas of how best to show the data please let me know! Thanks!
I managed to sort it out. Add the unique ID column (in whole number format) in y-axis
4 Replies
- FarhanAhmedCommunity Champion
try Add performance% in y-axis as well
- christinaxxxHelper I
I managed to sort it out. Add the unique ID column (in whole number format) in y-axis
- christinaxxxHelper I
Thank you, though it doesn't seem to be the way
- FarhanAhmedCommunity Champion
Good