Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Spreadsheet with data like this

Label Data
PA_1  1
PA_2  2
PB_1  3

with hundreds of rows.

I want to create a scatter graph where the x-axis contains the names in the label column. Instead, the graph x-axis has numbers instead of the text I want.

This question is similar to Excel scatter chart, with grouped text values on the X axis, but the answer that is given would not make sense given the number of data points I have.

To be clear I want to label the axis, not the individual data points. Is there a way to do this that I am not noticing?

share|improve this question
up vote 0 down vote accepted

That is odd....

However, you can mimic the scatter plot by choosing a line chart and then just format the data series line color to be "no line". You should then get your labels on the horizontal axis.

share|improve this answer
Just tested that out and it works. I ended up using a different software package to solve the problem but thank you regardless. – VBwhatnow Jun 10 '14 at 14:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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