Excel Chart: Transparent Fill

[Rujad]

I would like to create an Excel Area chart with a transparent fill so the grid lines can be seen. The "Transparency" option under fill effects is unavailable when I format the series.
Alternatively, is it possible to display the grid lines in front of the series bars, area, etc.?
Thanks,
Russ Dobbins

 

[SkipVought]

Try using NONE or NO FILL for the plot area fill Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Rujad]

Thanks. However, not quite what I'm looking for. Choosing NONE reduces the area to an empty box and defeats the purpose of the area chart. I'd like to see transparent color that allows the grid lines to be seen.
Russ

 

[SkipVought]

when you say "grid lines" are you referring to the Chart gridlines that you format on the x & y axis

OR...

the lines on the Excel spreadsheet?

'cuz CHART GRIDLINES don't need any level of transparancy or not!!! Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Rujad]

I am looking to see the Chart axis lines through a colored bar or area chart. There seems to be an option for transparent fill but its always greyed out.

 

[SkipVought]

I see what you are saying -- I have no answer :-( Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Rujad]

Thanks for thinking about it.
Anyone else want to give it a try?