I'd like to create a scatter chart but force all the data points into
one column for each series (as poorly illustrated below if viewed using
fixed font).

x x
x
x x

x
x x


x


Series A Series B


There are a few issues I'm trying to work around. First, scatter
plots seem to require a numeric value. If I have text in the first
column of data, then the chart will spread the data points
horizontally. If I create a numeric "label" in the first column, I
at least get the visual effect I'm looking for but then I have to
manually create a text box with the series name below each series.
This is tedious since I'd like to plot lots of series and would like
to eventually automate chart creation via a macro. I can't find any
way to have a text label in the x-axis that references a cell from the
worksheet.

Stock charts get me pretty close but I really want to display all data
points as discrete points on the chart.

Any ideas? Any help is much appreciated,
Andy