View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default using "transparency" option on chart settings

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.