Custom Chart Fill Color for workbook

[Megumi Takahashi]

Hi,

I am looking for the way to set custom colors for Chart Fills of Excel's color palette in my code. (From Excel 2007 file, Main Menu -> Excel Options -> Save -> colors...) I am able to set Palette colors by using workbook.SetPaletteColor(...) in my VB code. However, That function is for the standard colors, not for Chart fills colors.

I am using Syncfusion.XlsIO.Base Version 6.303.0.6.

Thank you in advance.

[John Bowlin Bosco K]

Hi Megumi,

Thank you very much for your interest in Syncfusion Products.

Using Essential XlsIO, the custom color can be set by using the method of SetPaletteColor of workbook. To set the custom colors for chart fill, we can use SetPaletteColor(9,Color.FromArgb(153,153,255));
This will set the color that you want to set for the workbook and the RGB color value used in the above code specifies one of the chart fills color. Please try your sample with this code and let us know if this helps you.

Please let us know if you need any further assistance.

Thanks,
Pauline Bosco