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

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

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

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

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