| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to change axis labels to text?
Please help!! i am making scatter plot charts with element names (e.g. SiO2)
along the x-axis but the programme has put all the x-axis labels as a series of numbers (1, 2...etc.) How do i change this back?? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to change axis labels to text?
Hi,
XY scatter chart will only display numbers on the axes. A line chart will display categories on the X Axis. If you are using a Line chart use the Source Data dialog to specify the range containing category labels. Right click chart and pick Source data from context menu. See here for more detail on the differences between Line and xy-scatter charts. http://peltiertech.com/Excel/ChartsH...ValueAxis.html Cheers Andy frustratedgeochemist wrote: Please help!! i am making scatter plot charts with element names (e.g. SiO2) along the x-axis but the programme has put all the x-axis labels as a series of numbers (1, 2...etc.) How do i change this back?? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to change axis labels to text?
Andy, you are a genius!!! thank you!
"Andy Pope" wrote: Hi, XY scatter chart will only display numbers on the axes. A line chart will display categories on the X Axis. If you are using a Line chart use the Source Data dialog to specify the range containing category labels. Right click chart and pick Source data from context menu. See here for more detail on the differences between Line and xy-scatter charts. http://peltiertech.com/Excel/ChartsH...ValueAxis.html Cheers Andy frustratedgeochemist wrote: Please help!! i am making scatter plot charts with element names (e.g. SiO2) along the x-axis but the programme has put all the x-axis labels as a series of numbers (1, 2...etc.) How do i change this back?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change tick mark labels in z axis from values to texts? | Charts and Charting in Excel | |||
| Change the space used for my x-axis labels | Charts and Charting in Excel | |||
| Can't change x-axis labels | Charts and Charting in Excel | |||
| X-axis labels -- text "jan" "feb", comes out "1" "2" etc.... | Charts and Charting in Excel | |||
| X-axis labels -- text "jan" "feb", comes out "1" "2" etc.... | New Users to Excel | |||
Linear Mode
