how to set horizontal axis label

**Orongo** · 01-05-2013, 11:26 AM

Hi

I am writing out an array of double into a chart and it gives me the horizontal axis label as 1,2,..,6. But I want the text to be according to a string array with names. Can this be done? So far my code looks like

Please Login or Register  to view this content.

**MrShorty** · 01-05-2013, 12:36 PM

I don't see where you are assigning anything to the .xvalues property of the series object. In a scatter plot, when nothing is assigned to .xvalues, the chart assumes you wanted the count numbers {1,2,3,4,...}.

Is there a specific reason you are using a scatter plot? A line chart uses a category axis. In a line chart, you could assign the range containing "names" as the xvalues, and the x axis should be labeled with those string values.

If you still need a scatter plot, you could plot a dummy series that lies on the x axis, then use Rob Xovey's XY data labeler add in (use site's search engine for link to download as it is given in many places). Plot the dummy series, then use the add in to label the points with the string array.