XY (scatter) plot x axis labels

[Elsa Lewis]

Does anyone know how to use words/categorical data instead
of a numeric scale for the x axis in an XY (scatter) graph?

Although I select the categorical data set, excel puts in
the numbers 0, 1, 2, 3 etc instead.

Thanks!
Elsa

 

[dvt]

Does anyone know how to use words/categorical data instead
of a numeric scale for the x axis in an XY (scatter) graph?

I'd use a dummy series. You can start with Jon Peltier's excellent example
at
http://www.geocities.com/jonpeltier/Excel/Charts/DummySeries.html#ArbAxis.

Dave
dvt at psu dot edu