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
-
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
-
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
-
amy.zhao
-
- Posts: 2774
- Joined: Wed Jun 27, 2012 8:50 am