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?


2 Answers 2


If your x-axis is numerical, it works. Rename "alpha", "beta", "gamma" to 1, 2, 3 respectively, to make the dots be on top of each other. See test file

enter image description here


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


  • 2
    There is no way to have multiple dots for v1 on top of each other?
    – Nicolas
    Commented Jul 29, 2019 at 10:18
  • @Nicolas nope, the aggregation is the only way
    – user0
    Commented Jul 29, 2019 at 10:21
  • Aggregation fundamentally changes the data, it is not a solution for this whatsoever. If Sheets simply won't collapse non-numeric labels and align the data points vertically instead of staggering them, then the "only way" is to use another product. Commented Jan 4 at 20:30

Your Answer

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

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