Hello,
Let's say I have data like this:

A 1
A 2
A 3
B 4
B 2
C 1
C 5
C 0

I want to create an XY scatter plot where the values in the first column are
the X-Axis and the values in the second column are values for the Y-Axis.

Right now, I can only get numeric labels for the X-Axis. I want the labels
to be text, namely A, B and C

How can I do this *programmatically* in VB.NET or C#? I know there are Excel
tool add-ins that allow this to be done manually, but I am doing some
automation.

My only 2, non-optimal, solutions thus far a
1. To hide the numeric labels and manually try to place the text labels via
text boxes using the size of the chart and other funky things to create an
algorithm. Very ugly
2. To use a line chart, not show the lines and treat each row as a series.
This works well until I get over 255 data points then I run into the 255
series limit in Excel 2003 (and not fixed in 2007). Then I get into the
situation where I have to create multiple worksheets and charts. Again,
better than (1), but still ugly.

Any help would be appreciated.

Thanks.