Results 1 to 3 of 3

Print a chart

This is a discussion on Print a chart within the Excel Questions forums, part of the Question Forums category; hi! Is there any way to print two charts in same chart window one upon another which are both transparent ...

  1. #1
    Board Regular
    Join Date
    Feb 2003
    Posts
    69

    Default Print a chart

    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

  2. #2
    Board Regular NdNoviceHlp's Avatar
    Join Date
    Nov 2002
    Location
    Manitoba Canada
    Posts
    1,406

    Default

    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

  3. #3
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,165

    Default

    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
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm
    (My other life: http://damonostrander.com )

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com