Transparent colours on chart?

  • Thread starter Thread starter Kristin
  • Start date Start date
K

Kristin

Hi,
I have a 3D column chart and I'd like to show transparent
colours for one of my series, so that the series' behind
it can be seen. Is there any way to do this?
Any help is appreciated as always!
Thanks,
Kristin
 
AFAIK, transparency in charts is only built in to the latest version of
Excel on the Macintosh, and is not available in the Windows version.

For a column chart, you can simulate the effect by pasting a transparent
shape onto the column series, but this doesn't work on an area chart.
http://j-walk.com/ss/excel/usertips/tip071.htm

Perhaps you could use a different type of chart, or a combination of
chart types. Jon Peltier has instructions for creating combination charts:


http://www.geocities.com/jonpeltier/Excel/Charts/ComboCharts.html#ComboCht
 
Back
Top