Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is there a better way to imbed an Excel Chart? (PP97)

    I'm creating a presentation with about 20 Excel charts. I copy the chart from Excel and paste it into PowerPoint, resize the chart, and do it again for the next chart. Is there a more efficient way to bring the charts into PowerPoint so they're full size? (I have to do this every week -- tedious!)
    Thanks,
    Caroline in lala-land

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a better way to imbed an Excel Chart? (PP97)

    You could use a macro in Excel to do the work for you.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Is there a better way to imbed an Excel Chart? (PP97)

    Personally - I'd take the Excel data and place it in the PPT datasheet. Charts created this way have a colour scheme that matches the presentation, they don't need to be resized and just generally look better.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    San Diego, California, USA
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a better way to imbed an Excel Chart? (PP97)

    In PowerPoint 2000, you can link the charts from a workbook by using functions embeded in the object slide layout. It has been awhile since I worked on the 97 version. I hope this will work for your.

    You will need to change the slide layout to either a large object or object.
    If you are unfamiliar with this, you are able to change the format of each slide from a bullet list to a movie clip slide and several in between. You can find this feature under the menu Format - Slide Layout. I would recommend you use either the large object or object with title layout. When you select either of these layouts, you will see a caption to "double click to add object" on your PowerPoint slide, do that double click and a dialogue box will prompt you for several things.
    1. Create from:
    a. New
    1. Object Type

    b. File (You should use this one)
    1. Link (Definitely select this one)

    2. Display as icon (do not select)

    Browse to your Excel file and select it for use and press OK until you are back to your PP slide.
    Now you will see your last active worksheet in that workbook displayed on your PP slide.
    Double click your Excel worksheet and either create your chart or select the chart tab you want to display.
    I recommend that you place the charts on their own worksheet not co-mingled on the data worksheet.

    After you are finished with your chart making, Save & Exit from excel and you will notice that your changes did not seem to take effect.
    Here's the trick,
    Right click and select 'update link' and Whalah!

    Your chart now shows in PowerPoint and is linked. So, any changes you make and save to the workbook in the future will automatically update the charts and when you are finished, OPEN the PowerPoint and you will be prompted to updated the links. Select 'Yes' and then save your PP. You are now done.

    One Workbook - One PowerPoint.
    No More Copy, Paste, and Resize.

Posting Permissions

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