Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Sep 09, 2015 9:59 pm

How can you change the background color of the legend in a chart?

I'm looking to do what I can do in Excel directly and specify a Solid Fill of White.

Thanks.

daveb
 
Posts: 12
Joined: Mon Jul 27, 2015 4:07 pm

Thu Sep 10, 2015 6:10 am

Hello,

Thanks for your inquiry.
So sorry that our product doesn't support this feature at this stage. We will consider adding it in our future upgrade.

Best Regards,
Sweety
E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Fri Oct 23, 2015 8:50 am

Hi

Thanks for waiting.
The feature has been supported. Welcome to download and test Spire.XLS Pack Hotfix Version:7.8.43 .
Downloading link is http://www.e-iceblue.com/Download/downl ... t-now.html.
Sample code:
Code: Select all
Chart chart = workSheet.Charts[0];
XlsChartFrameFormat format= chart.Legend.FrameFormat as XlsChartFrameFormat;
format.Fill.FillType = ShapeFillType.SolidColor;
format.ForeGroundColor = Color.White;


Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2774
Joined: Wed Jun 27, 2012 8:50 am

Thu Oct 29, 2015 8:13 am

Hi,

Does Spire.XLS Pack Hotfix Version:7.8.43 solve your issue?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2774
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS