Two charts, one on top with transparent chart area

[Nyle Elison]

I would like to take two charts, placing one on top of
the other with the top chart having a transparent chart
area (As though I were laying one overhead transparency
on top of the other). I can't seem to find a way to make
the chart area transparent. Selecting "None" for the
chart border and area leaves a white background.

Any ideas?

Thanks!
Nyle Elison
(e-mail address removed)

 

[Debra Dalgleish]

You should also format the plot area with None for area and borders.

Jon Peltier has some code to align charts:

http://www.geocities.com/jonpeltier/Excel/Charts/AlignCharts.html

 

[Jon Peltier]

Also, while the chart is selected, it will not be transparent.

- Jon