Using Transparency

[Tony Dennison]

Hi,

Please can anyone help.
I am using a standard column graph and have two overlapping series.
I would like to 'ghost' one series behind the other.
The obvious way I thought of doing this was using Transparency.
As I am using Excel 2003, I tried:-

Format Data Series > Pattern Tab > Area > Fill Effect > Gradient.

There I found a to/from transperency box which seems as though it would do
what I wanted.
Unfortunately it is greyed out.

How do I activate this, and will it do what I want?

Thanks,

Tony Dennison

 

[Debra Dalgleish]

Transparency for chart objects is only available in the Macintosh
version of Excel. For a column chart, you can simulate the effect by
pasting a transparent onto the column series, as shown in the following
tip by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip071.htm

 

[Tony Dennison]

Debra,

Many thanks for your speedy help. You have saved me hours of frustration. I
would never have thought of that for an explanation. It is however a
disappointing outcome. I do not think the simulated effect will quite do
what I want.

Thanks and regards,

Tony

Thanks for the speedy reply