Forum Discussion

christinaxxx's avatar
christinaxxx
Helper I
2 years ago
Solved

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