I use SeriesCollection.setCategoryData() to set the text for the legend and along the x-axis of a chart. What I’ve seen is that if I don’t use it, than the categories are listed 1,2,3,etc. If I do use it, than the text displayed for each category, is the text displayed in the cells designated by the given range. What I need to know is, can the x-axis values remain 1,2,3,etc., while the categories listed in the legend are 1-Cat1,2-Cat2,3-Cat3, etc. (where Cat# is the category names listed in the provided range)?
Thanks for any assistance.