using "transparency" option on chart settings

[Mike D]

When making a chart, I see there is a "transparency" option (under "fill
effects"), but can't figure out what it does or how to use it. Can anyone
explain how to use this option?

 

[Andy Pope]

Hi,

It's not available to charts. The dialog is also used for Fill Effects
in shapes. And when used on a shape that section of the dialog in enabled.

If you are after using transparency effect see John Walkenbach's work
around.
http://j-walk.com/ss/excel/usertips/tip071.htm

Cheers
Andy

 

[JE McGimpsey]

Note that Transparancy *is* available to charts in XLv.X and XL04 for
Mac.

 

[Jon Peltier]

Which satisfies a couple percent of Excel users.

Excel 12 is reported to have a whole new chart rendering engine, so if you
just wait a bit longer, this capability may become available to Windows
users, too.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Researcher08]

That link is great, but it only works with bar and line charts. What about
pie charts?

 

[Jon Peltier]

I believe partial transparency is possible in Excel 2007, but formatting is
not enough of a reason to put up with the problems with charting in 2007.
Besides, pie charts are generally an inferior means of conveying
information.

- Jon