We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Custom Chart Fill Color for workbook

Thread ID:





98842 Apr 4,2011 06:35 PM UTC Apr 5,2011 05:51 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Megumi Takahashi
Asked On April 4, 2011 06:35 PM UTC


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 [Syncfusion]
Replied On April 5, 2011 05:51 AM UTC

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.

Pauline Bosco


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon