Assuming your data is JUST as you show it, there is no way to make an XY
chart of this,
an XY chart needs pairs of numeric data (like the graphs you made in Grade 9
algebra - if you are North American) You have what is called "category data"
for you x-values.
I think you need a Line chart
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Refresher" wrote in message
...
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.