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

[Tom]

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

 

[Andy Pope]

Hi,

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

Cheers
Andy

 

[Jon Peltier]

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

- Jon

 

[Tom]

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

 

[Andy Pope]

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