Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    London, Gtr London, England
    Posts
    357
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying & Pasting Graphs (Excel 2000)

    I run a VBA routine/macro which plots the resultant numbers from a range onto a pre-defined graph. The routine is run again and new numbers now occupy the range + graph is updated. How can I store and send each graph to a new sheet/new work book and have a collection of graphs? Thanks.

    Farmer

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Copying & Pasting Graphs (Excel 2000)

    How are the base numbers changing? Is it automatic/randomised or is the operator doing some manual changes and then wants to graph this as a new data set?

    I am guessing that it is manual so I would just duplicate the sheet which contains numbers and graph and modify the numbers on the new sheet (the graph should update automatically).

    If this is the case, VBA is probably not required.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Copying & Pasting Graphs (Excel 2000)

    Hi Farmer,
    In order to get a 'collection of graphs', you'll have to keep a copy of both the chart and its underlying data.

    If they're both on the same worksheet, you could simply copy the whole worksheet and paste it onto a new one, then update the chart's worksheet references. That'll keep the whole lot in the one workbook. If the chart is on its own sheet, you'll need to duplicate that and update the references.

    Alternatively, you could use SaveAs to make a copy of the workbook. This would avoid the need to update the chart's worksheet references.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying & Pasting Graphs (Excel 2000)

    You can copy a picture of the graph:
    - Hold the shift key and press Edit, Copy picture
    - choose the preferred option(s)
    - paste whereever you like.

    Advantage: Having many charts in Excel consumes resources.
    When you exceed approximately 50 charts you might start to run into resource trouble (system dependant).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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