+ Reply to Thread
Results 1 to 2 of 2

VBA to copy paste chart side by side

  1. #1
    Registered User
    Join Date
    03-10-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    9

    VBA to copy paste chart side by side

    Hi Everyone,

    I really need your help, I already exhausted all resources and done several research on the VBA to copy and paste charts side by side.
    I improved on this macro but cant seem to make it work, that is to paste the charts side by side the result is the charts were overlapping.

    recCount = 1
    Application.ScreenUpdating = False
    For Each ws In ThisWorkbook.Worksheets
    For Each ch In ws.ChartObjects
    ch.CopyPicture xlScreen, xlBitmap
    With destWB.Worksheets(2)
    .Paste .Cells(recCount * myOffset + 4, 2)
    End With
    recCount = recCount + 4
    Next ch

    Could anybody point out what's wrong with the code to make the charts paste side by side?

    Appreciate it very much.
    Bert

  2. #2
    Registered User
    Join Date
    03-10-2015
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    9

    Re: VBA to copy paste chart side by side

    Any help please..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare 2 sets of values in side-by-side Stacked Column chart
    By dlaudenschlager in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-21-2016, 01:34 PM
  2. [SOLVED] How can I change Chart.Axes(xlValue) from left side to right side ?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-15-2014, 02:18 PM
  3. [SOLVED] Possible to use pivotcharts to analyse data for two series side by side in a chart?
    By maladrat in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-08-2014, 04:08 PM
  4. Combine side-by-side data series with 3D column chart
    By isburns in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-04-2009, 04:15 AM
  5. excel should cut & paste lists side by side to save paper
    By Richierich in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2006, 08:45 PM
  6. [SOLVED] How do I make a stacked column chart with side-by-side comparison.
    By Tim in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2005, 11:05 PM
  7. Data markers in a stacked chart will not sit side by side by month
    By WCH CHART PERSON in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-28-2005, 12:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1