I have a dataset where I have on each row data associated with an item that has a name (alpha, beta, gamma in the example), as follows:

Dataset example

I now want to create a scatter plot where the X axis corresponds to the names (alpha, beta, gamma) and the Y axis corresponds to the values in v1. But I want to only have one entry of alpha, beta, gamma on the X axis, respectively.

This happens automatically if the X axis values are numbers, but I can't figure out how to do it if they are strings.

I don't want to have to assign each name a number and then modify the x-axis to show these names at the given numbers because the dataset is quite large.

How can I achieve this?


1 Answer 1


You will need to Aggregate them under Median, Average, Sum, Max or Min like:


  • 1
    There is no way to have multiple dots for v1 on top of each other?
    – Nicolas
    Jul 29, 2019 at 10:18
  • @Nicolas nope, the aggregation is the only way
    – user0
    Jul 29, 2019 at 10:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.