Formatting and Transparencies

tstevens

New Member
Joined
Sep 1, 2006
Messages
29
I'm trying to format the plot area of a chart and I want to use a gradient where one of the colors is transparent. Is this possible? Everything I can find seems to point to no with XP and yes with MAC. If this is true why does it give you the transparency option in the fill effects window?

Thanks for any help.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi tstevens,

Even though Excel supports gradient fills where one (or both) of the colors is transparent in general (e.g., for shapes), it does not for the plot area. However, to get the same effect you should be able to make the plot area totally transparent and place an appropriately sized and filled rectangle behind it.

Damon
 

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi again tstevens,

You can't put the shape between the Plot Area and the Chart Area, but you can put it behind both by using Send to Back (Draw > Order > Send to Back on the Drawing toolbar). To see the shape through the chart you must then also set the fill color of the Chart area to None.

Unfortunately, when I tried this in Excel 2002, the screen redraw often goes into an infinite loop. But when it does I seem to be able to stop it by resizing the shape. You might want to give it a try and see if it works for you.

Damon
 

Forum statistics

Threads
1,141,761
Messages
5,708,367
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top