Can legend text be different than the category data listed along the x-axis of a chart?

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.

Hi,


Could you kindly create your sample chart in MS Excel manually, save the file and post it here. This way, we can understand your needs and help you how to do it via Aspose.Cells APIs.

Thank you.

Hi,

Please download and try the latest version:
Aspose.Cells
for .NET v7.2.0.5



Please set Series.Name. The legend text should be as the Series.Name.