Print a chart

[saurabh]

hi!

Is there any way to print two charts in same chart window one upon another which are both transparent and are set one upon other on an excel sheet.
I need vba code to do this..

Thanks and regards
Saurabh

 

[NdNoviceHlp]

I'm not sure if this is what you are trying to do but couldn't you just add the 2 chart series to one chart and then print the single chart?
edit: the macro recorder is also a very useful tool when dealing withchart and their manipulation

 

[Damon Ostrander]

Hi Saurabh,

Here is a macro that will print the chart named Chart 2 on Sheet1 and any other charts that might be overlaying it or under it. It actually prints the chart by printing the underlying cells. If the underlying cells contain data and that data shows through because ALL the charts are transparent, you will need to put a filled rectangle under the charts if you don't want the data showing through.

Sub PrintOverlayedCharts()
'prints multiple overlayed charts
Dim PrintRange As Range
With Sheet1.ChartObjects("Chart 2")
Set PrintRange = Sheet1.Range(.TopLeftCell, .BottomRightCell)
PrintRange.PrintOut copies:=1
End With
End Sub