Excel column chart: transparent fill

[messsp]

Hi!
I'm trying to make transparent the columns of my Excel chart. If you go to Format Data Series/Fill Effect, the transparency option is not available. Any ideas on how to solve this? Thanks

 

[SkipVought]

Hi,

Temporarily add a rectangle shape to your SHEET.

Format Object to shade with transparanct.

Copy the shape.

Edit the chart.

Select the series.

Edit/Paste

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[GlennUK]

What about Format/Select Data Series/Patterns and set Area to None?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[messsp]

Thanks!
I thought about it but the problem is that when I re-size the chart area, the object keeps the same size and doesn't adjust to the new dimension. I even tried to group the object with the chart but this doesn't seem possible. This is why I was wondering if a more "stable" solution exists...

Ciao

 

[SkipVought]

Do not understand???

I can resize my chart every way but Friday and the columns resize fine as well.

Could you be more specific?

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[AndyPope]

Hi Messsp,

Skip's suggestion will work. It sounds like you didn't have the column series selected when you pasted the autoshape. Therefore rather than been used as a fill it is simply a object within the chart.

Cheers
Andy