Graph Transparency

[consjer]

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!

 

[Justin_B]

Having the same problem..

Any luck, clues ??...??

 

[Sal Paradise]

It is doable with the wonderful world of VBA coupled with the insight of peltiertech.com.

 

[Justin_B]

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

 

[Justin_B]

This is a great method..

http://spreadsheetpage.com/index.php/tip/creating_a_transparent_chart_series/


Given that you can import a picture in the drawing object and affect the transparency it opens up infinite possibilities for colours. .

 

[consjer]

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!

 

[Saiya]

This is a great method..

Excel Tips From John Walkenbach


Given that you can import a picture in the drawing object and affect the transparency it opens up infinite possibilities for colours. .

maybe next time instead of linking to inexistent content (now at least), copy the code here.

 

[Jon Peltier]

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.