Scatter chart horizontal axis labels

[oereich]

Hi,
I am making an excel scatter chart for a school project, everything is done except the labels I would need to appear on my horizontal axis would be classes: 0, [1,2], [3,4], [5,7], 8+

At the moment, I have numbers simply: 1, 2, 3, 4, 5 to represent the classes.

Is there a way to make the proper labels appear?

Thanks

 

[Jerry Sullivan]

Hi and Welcome,

You can find the steps in this article
http://office.microsoft.com/en-us/excel-help/change-the-display-of-chart-axes-HP010007448.aspx

...under the heading "Change the text of category labels"

 

[tusharm]

Use a Line chart (rather than a XY Scatter chart) and you can have any text in the X values.

If you must use a XY Chart, you will have to simulate the effect. Add a dummy series which will have all y values as zero.

Then, add data labels for this new series with the desired labels. Locate the data labels below the data points, hide the default x axis labels, and format the dummy series to have no line and no marker.

Hi,
I am making an excel scatter chart for a school project, everything is done except the labels I would need to appear on my horizontal axis would be classes: 0, [1,2], [3,4], [5,7], 8+

At the moment, I have numbers simply: 1, 2, 3, 4, 5 to represent the classes.

Is there a way to make the proper labels appear?

Thanks

 

[Jerry Sullivan]

Thank you Tushar. I didn't take into account the nature of the Scatter Chart in my response.

 

[tusharm]

Thank you Tushar. I didn't take into account the nature of the Scatter Chart in my response.

 

[oereich]

Thanks a bunch!

Use a Line chart (rather than a XY Scatter chart) and you can have any text in the X values.

If you must use a XY Chart, you will have to simulate the effect. Add a dummy series which will have all y values as zero.

Then, add data labels for this new series with the desired labels. Locate the data labels below the data points, hide the default x axis labels, and format the dummy series to have no line and no marker.