Changing the background color of an excel chart in C#

Question

0.00/5 (No votes)

See more:

Excel-2016

I'm working on creating an Excel Chart from my C# application that pulls data out of my SQL Server database, and using that data, creates some Charts in an Excel instance. I have a pie chart that displays with the data, and all is well, accept I want to change the background color of the ChartArea and maybe use a gradient to add a little visual variation. I'm having trouble figuring out how do do that in C# using OLE. It looks like Office 16 is installed. This should be simple, but I'm having trouble with this. I saw a chart.ChartArea.Fill.BackColor property, but it's read only (I can't set it). Not sure how to do this programmatically. Any ideas would be helpful. Thanks.

What I have tried:

I've searched (bing, google)around, but can't find anything. There are variations, but not my particular problem. I can change it manually, when the chart in my worksheet comes up, but I want to be able to do it programmatically.

Posted 30-Oct-18 3:29am

Matthew Menard

Updated 30-Oct-18 4:03am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alek Massey · Accepted Answer · 2018-10-30T04:04:00

Solution 1

Access it by the RGB property of Backcolor.

chart.ChartArea.Fill.BackColor.RGB = RGB(221, 221, 221)

Also if you want hints at how to do something using C# programatically in Excel that you know how to do manually, record a macro. Do it manuually with the macro recording. review the macro code afterwards for how to do the task in VBA. Then you have hints of how to do it in C#.
Cheers!

FillFormat Object (Excel) | Microsoft Docs[^]

Posted 30-Oct-18 4:04am

Alek Massey

Updated 30-Oct-18 5:10am

v3

Comments

Matthew Menard 30-Oct-18 10:21am

I realized that I needed the ForeColor afterall. But that same structure work great. Any idea on how to create a gradient on that, from one color to another?

Alek Massey 30-Oct-18 11:10am

I updated the solution with a link.

Changing the background color of an excel chart in C#

1 solution

Solution 1

Add your solution here

Preview 0

Changing the background color of an excel chart in C#

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us