Graph Transparency

consjer

New Member
Joined
Feb 12, 2009
Messages
2
Hi,
I am working on an area graph with 2 data series and I want to make the color in the foreground transparent. I have currently tried to Format Data Series --> Fill Effects --> Gradient, however I am unable to adjust the transparency. Do i need to select something to be able to adjust this field?

Currently working with Excel 2003 SP3

Any help would be great! Thanks!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Justin_B

Board Regular
Joined
Nov 16, 2006
Messages
54
Thanks for the quick reply Sal!

Found a couple of posts about this - one using VBA the other using transparency defined in an Auto-Shape, then copied into the fill for the chart series.

Both look viable.


Thanks again.

JB
 

consjer

New Member
Joined
Feb 12, 2009
Messages
2
Thanks for the help on this. I was using an area graph and have just decided to change it up. I like the work around though for future graphs!
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
This page existed in 2009. It is an old obscure workaround, and since Excel 2007 it has been possible to format the chart elements directly to have transparent fills.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,993
Messages
5,622,041
Members
415,875
Latest member
Tarali

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