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?

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

Mike D wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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

In article ,
Andy Pope wrote:

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.

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/
_______


"JE McGimpsey" wrote in message
...
Note that Transparancy *is* available to charts in XLv.X and XL04 for
Mac.

In article ,
Andy Pope wrote:

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.

I have had the same problem with the transparency thingo - I thought a work
around would be to get the font colour RGB numbers that correspond to varying
levels of transparency (assuming a white background)? e.g., the colour
Red = 36
Green = 74
Blue = 159
at 75% transparency on a white background approximately equates to the colour
Red = 95
Green = 123
Blue = 197

Is there anyway of finding out what it is exactly?

Otherwise the link http://j-walk.com/ss/excel/usertips/tip071.htm is a good
alternative

thanks!

Victoria



"Jon Peltier" wrote:

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/
_______


"JE McGimpsey" wrote in message
...
Note that Transparancy *is* available to charts in XLv.X and XL04 for
Mac.

In article ,
Andy Pope wrote:

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.

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

"Victoria J" wrote:

I have had the same problem with the transparency thingo - I thought a work
around would be to get the font colour RGB numbers that correspond to varying
levels of transparency (assuming a white background)? e.g., the colour
Red = 36
Green = 74
Blue = 159
at 75% transparency on a white background approximately equates to the colour
Red = 95
Green = 123
Blue = 197

Is there anyway of finding out what it is exactly?

Otherwise the link http://j-walk.com/ss/excel/usertips/tip071.htm is a good
alternative

thanks!

Victoria



"Jon Peltier" wrote:

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/
_______


"JE McGimpsey" wrote in message
...
Note that Transparancy *is* available to charts in XLv.X and XL04 for
Mac.

In article ,
Andy Pope wrote:

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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Researcher08" wrote in message
...
That link is great, but it only works with bar and line charts. What about
pie charts?

"Victoria J" wrote:

I have had the same problem with the transparency thingo - I thought a
work
around would be to get the font colour RGB numbers that correspond to
varying
levels of transparency (assuming a white background)? e.g., the colour
Red = 36
Green = 74
Blue = 159
at 75% transparency on a white background approximately equates to the
colour
Red = 95
Green = 123
Blue = 197

Is there anyway of finding out what it is exactly?

Otherwise the link http://j-walk.com/ss/excel/usertips/tip071.htm is a
good
alternative

thanks!

Victoria



"Jon Peltier" wrote:

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/
_______


"JE McGimpsey" wrote in message
...
Note that Transparancy *is* available to charts in XLv.X and XL04 for
Mac.

In article ,
Andy Pope wrote:

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.