On Fri, 8 Aug 2008, in microsoft.public.excel.charting,
JOHN PERKINS 31 said:
I need to show numeric data on the y-axis versus categories, not numbers, on
the x-axis in a scatterdiagram (in other words there will be several
different y-axis data poits for each x-axis category) . How do I do this in
an excel scatter graph?

Make a dummy category x-axis by creating a range with evenly-spaced
x-values, and y-values all zero. This will create a row of data points
along the bottom. Then give them data labels (any type will do).

Then change the data labels to read your required categories. You can
either do this by manually editing them or by using one of the useful
free add-ins for chart labeling.

For dummy axes google "excel dummy axis" or "excel arbitrary axis", and
for automatic data labels try google "excel chart labeling"

Or, you could choose a Line Chart type, and just let the chart use up to
256 series. You can make the series look all the same by formatting the
first one to your liking, then using a cursor key and F4 to quickly step
through all the series repeating the same format change.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.