Excel 2003: How to make transparent columns in Excel chart?
 

If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas

Excel 2003: How to make transparent columns in Excel chart?
 

Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
s.com...
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas

Excel 2003: How to make transparent columns in Excel chart?
 

Yes, I think it's for compatibility with shapes, and with Mac charts.

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


"Andy Pope" wrote in message
...
Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
s.com...
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.

I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy - paste.
But i wonder what is the slider for if you can't use it?

Does anybody know have an idea?

Cheers,
Thomas

Excel 2003: How to make transparent columns in Excel chart?
 

Thanks! That was very helpful indeed...
Could you tell me now where to find this dialog?


Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy

Excel 2003: How to make transparent columns in Excel chart?
 

Hi,

Not sure what you mean by 'Find it'. The dialog is the one shown, for
example, when formatting a shape.
Select shape and press F1. On the Colors and Lines tab click the Color
dropdown.
From the list pick Fill Effects.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tom" wrote in message
oups.com...
Thanks! That was very helpful indeed...
Could you tell me now where to find this dialog?


Hi,

My guess would be re-use of an existing dialog.

Cheers
Andy