Forum Discussion
How to show value instead of aggregate in scatter plot
How to show value instead of aggregate in scatter plot?
I just have table like this
X. Y
aa. 2
aa. 3
aa. 4
bb 5
I should show aa as 4 data points(without summarising to 9) and bb as 1 data point using scatter plot. Kindly help
3 Replies
- Happy2023_05
Helper I
Can someone please help me on this?
Scatter plot when giving x-axis text and y axis - number field as don't summarize to see individual data points but I get this error.
X axis and yaxis aren't playing together nicely. Because one of the axis expecting numerical value. How to fix this error and how can I see individual data points without aggregation?
- AnonymousNot applicable
Hi Happy2023_05
For scatter plot , X axis and y axis aren't playing together nicely , replace the X axis field with a numerical value or change the Y axis field values to summarizations . So if you want through X axis to dispaly your X value , you need to add a column and put it in Legend .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - Happy2023_05
Helper I
Thanks for responding.
I don't want to sumamarize y columns. I want to see it as separate data points and X column should be in x axis and used as legend. Is there any suggestion for this to achieve?