Excel Chart Transparent Background

I'm being stonewalled by VBA when attempting to assign a custom marker color AND transparency level on a radar chart. I've read there are some issues with order, but no matter where I try the .transparency parameter, I get the following error: Object doesn't support this property or method.

• Transparent Background Free
• Excel Chart Transparent Background Images
• Convert Image To Transparent Background

If I comment out the .transparency line in the following code, I get a great radar plot with markers colored by values in rngColors. I would just like to make them transparent so the underlying line plots come through as well. Any help or advice would be greatly appreciated.

Is there a way to make the chart background be transparent in Excel 2007? That is, I want to be able to see cells behind a chart or put to charts one on top of another and have both of them show up instead of the top plot area block the apearance of the bottom chart?

Regards,Adam

EDIT: Thanks to the link in the comments, the following code worked for me when run as a separate macro after assigning color. It's tricky though, and I don't know why. First I need to run the transparency code (below), then comment out .Solid, then run the color code (above), then the transparency code again (below), then it works. Yikes! I'm not too worried about optimizing now, but this seems to work regularly:

1 Answer

The information I found has proper syntax of .Format.Fill.Transparency = 0.5http://answers.microsoft.com/en-us/office/forum/office_2007-excel/macro-to-change-the-transparency-of-markers-in-a/6a9964a7-30ad-4412-a48f-2334e4ecd63d

Although there is discussion of bugs with that coding depending on your Excel version:http://www.mediafire.com/file/j2tnzlcizzm/05_09_10b.pdf

Transparent Background Free

Not the answer you're looking for? Browse other questions tagged excelvbaradar-chart or ask your own question.

How to fill a shape with transparent background color in Excel?

Normally, the shape we inserted into worksheet was filled with no transparency background color. If you want to fill a certain shape with transparent background color, you can try the following method.

Recommended Excel Productivity Tools

Bring tabbed editing and browsing to Office (include Excel), much more powerful than the browser's tabs. Free Download..

More than300 powerful advanced features for Excel, designed for1500 work scenarios, save70% time for you. Free Download..

Fill a shape with transparent background color in Excel

Please do as follows to fill a shape with transparent background color in Excel.

1. Right click a shape you need to fill with transparent background color, then click Format Shape from the right-clicking menu. See screenshot:

2. If you are using Microsoft 2016 and 2013, the Format Shape pane will pop up on the right side in current worksheet, please expand the Fill options under the Fill & Line tab, keep the Solid fill option selected, specify a background color in the Color drop-down list as you need, then enter a transparent percentage into the Transparency box. And finally close the Format Shape pane. See screenshot:

And if you are using Microsoft 2010 and 2007, a Format Shape dialog box will pop up as below screenshot shown. Please select Fill in the left bar. In the right side of the dialog box, keep the Solid fill option selected, specify a background color in the Color drop-down list as you need, then enter a transparent percentage into the Transparency box. And finally close the dialog box.

You can see the specified shape is filled with transparent background color as below screenshot shown.

Related articles:

Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

• More than300 powerful advanced features, designed for1500 work scenarios, increasing productivity by70%, give you more time to take care of family and enjoy life.
• No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
• Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,
• Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
• 110,000 highly effective people and 300+ world-renowned companies' choice.
• 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

• Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!

Excel Chart Transparent Background Images

Convert Image To Transparent Background

• Would you please list applicable product versions on software articles? E.g., Excel 2003,2007,2010

  • Dear Anon,
    Thank you for your comment. Your suggestion will be taking into consideration. And the article is now updated.
• To post as a guest, your comment is unpublished.
  How about putting a date at the top of your webpages so I can assess its applicability. Just because other dumbass sites do an inept job of showing article dates, doesn't mean that you should to. Be worth a darn instead of being a lame get-by-with-the-minimum-effort slacker.
  By the way, on IE11 this page refuses to scroll from the mouse scroll wheel. It makes the page frustrating to navigate.