We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Setting automatic color for LineChart lines

Hello Aspose team!

I recently bumped into problem with Aspose.Cells product regarding Chart drawing. Here is the detailed description:

  1. We need to force lines of the LineChart to select colors automatically, but we need to adjust other properties of the lines (such as Line.Style and Line.Weight)
  2. When you set Line.IsAuto = true, color is selected automatically, but Style and Weight are become overwritten by automatic settings. If you change values of Style and Weight properties, Line.IsAuto will become false automatically.
  3. No matter what you do in previous points, property Line.IsAutomaticColor will be equal to true, so this means, that colors will be selected automatically.
  4. But this doesn’t happen for case, when you want to embed your excel into power point presentation. When you call chart.ToImage(), image will be only in black and white colors, although, when you double-click on the embedded excel, chart will be colored.
  5. series.MarkerForegroundColorSetType = FormattingType.Automatic doesnt work either.

What wold you advice in this case? Or is it a bug, that chart.ToImage() is producing black and white images even when Line.IsAutomaticColor = true?

We are using fully-paid 7.1.0 License for Aspose.Cells. If you need any additional information - just ask.

Thank You in advance,


Hi Denis,

Please try our latest fixed version v7.1.0.5: Aspose.Cells for .NET v7.1.0.5

If you still find any issue, kindly separate the issue(s) regarding Aspose.Cells product, create a sample console application, zip it and post it here, also attach some screen shots for the problems, we will check your issue(s) soon.

Thank you.