Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying graph from one spreadsheet to another (200

    Can you tell me the easiest way to insert a graph from another spreadsheet into another seperate spreadsheet rather than have to re-do all the graph again.
    I tried to copy and past graph but graph is to small and l cannot enlarge it.
    see screenshot.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Copying graph from one spreadsheet to another (200

    If you want it as a chart and not just a picture, make sure you copy the chart and the source data to the new book. Then copy the new data into the sheet with the source data.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying graph from one spreadsheet to another (20000)

    Do you want only a "picture" of the chart, or should it be editable?

    If you want a picture:
    - Click once on the chart to select it.
    - Hold down the Shift key while clicking on the Edit menu.
    - The Copy item has changed to Copy Picture; select this and click OK.
    - Activate the other workbook.
    - Paste the picture (Edit | Paste or Ctrl+V)

    If you want the chart to be editable, you will have to copy the chart together with its source data to the other workbook.

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying graph from one spreadsheet to another

    Thats great thanks for that , the only problem l have is that the wording month isn overlapping the x-axis,is there any way round this?
    see screenshot

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying graph from one spreadsheet to another

    Either click on the word Month to select its text box, then dwag the border a bit downward, or click on the dark red background of the plot area and drag its bottom edge a bit upward (using the little black square in the middle of the bottom edge).

  6. #6
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying graph from one spreadsheet to another

    Thanks for that.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Copying graph from one spreadsheet to another

    <hr>dwag the border a bit downward<hr>
    Having an Elmer Fudd moment? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copying graph from one spreadsheet to another

    Is it weawwy that cweaw?

Posting Permissions

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