How to move labels in a R plot?

How do I change the horizontal axis labels on my 2007 Excel scatter plot?

• I set the information up correctly, but it still has the horizontal axis labels as numbers (1, 2, 3, 4, 5) instead of the names I want. How do I change this? It won't let me if I right-click them and then go to Select Data and then edit the labels. The same information is working fine in a bar graph.

• Answer:

  Format the horizontal axis > Axis Options > Axis labels: None Move the bottom of the plot area up a little if you need to by clicking it and dragging the bottom center sizing handle up. Insert a text box and enter whatever lables you like. You can adjust the font, font size, etc on Excel's Home tab. Use the space bar to get them to line up. Not very elegent I know, but it works. Note: you may want to format the text box to turn off the border. Good luck...