Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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 at 14:50

Your Answer

 
discard

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.