Free Support Forum - aspose.com

Request: chart.NSeries[i].Marker?

Hi Laurence,

first of all many thanks for your new release of Aspose.Excel! Thanks for including my requested features!

Now I have a new question and request:
Can you add an object “chart.NSeries[i].Marker”?


With your new dll I can set Line.Width and Line.Color but when setting this I get the DataMarkers for these lines (with ChartType.Line). Therefore I need to set the Datamarker’s color and maybe style like in Excel or alternative set them invisible!


And one other request: Can you change your code that
chart.NSeries[1].Line.Weight = WeightType.MediumLine;
can be set WITHOUT setting chart.NSeries[1].Line.Color = Color.Red;

This is because of I don’t know how many lines are getting into my Excelsheet at programming-time and to hold about 20 colors for these lines is bad programming. So I will use the functionallity of Excel wich is setting these colors automatic.


And some more question:
ChartType.ColumnStacked: When setting

chart.NSeries[1].Line.Weight = WeightType.MediumLine;
chart.NSeries[1].Line.Color = Color.Red;

my bars are getting a border in the color red. This is OK for me but I will set Bar.Backcolor = Color.Red like

chart.NSeries[i].DataLabels.Style.BackColor = Color.Black;


Thanks for your answer and support!

-Stefan

Hi Stefan,

About your first two requests, I will fix it ASAP.

About your last question,

ChartType.ColumnStacked:

chart.NSeries[1].Line.Weight = WeightType.MediumLine;
chart.NSeries[1].Line.Color = Color.Black;

I tested the above code. The border color of columns is black.


Hi Laurence,

thats’s right, the border gets the color but I want to set the bar-backcolor and therefore there is no function untill now.

Regards, Stefan

Hi Stefan,

I will add a new property “ASeries.Area” to enable you to do it. Now thanks for your patience.