I am unable to change the x-axis labels on a scatter plot in Excel 2010. I have month-wise precipitation data (jan feb mar.... on the x axis vs. depth of rain on the y axis) and am trying to get the labels on the x-axis to be jan feb mar. But excel inserts a default 1 2 3... label and will not even let me change it in the 'Select Data' > Horizontal Axis Labels field. I have tried the 'Layout' > Horizontal Axis Options as well with no luck. If I change the chart type to a column or even line plot, the labels work but for a scatter plot, looks like the default numbering pattern that excel inserts is the only option. Any help you can provide will be appreciated.
Thanks
Bookmarks