Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Insert Graph from Excel File (2000)

    I am trying to insert a Graph from an Excel worksheet into a Powerpoint presentation.

    I use the Insert | Object | Create from file | Browse to select the Excel presentation. However, I have not figured out how to choose the worksheet that is inserted, or to select the portion of the worksheet that I want to see.

    If I resize the graph window, it changes the size of the contents instead of clipping the contents as I would like to do.

    I end up with little portions of Excel grid showing around the borders of the Graph.

    Any ideas?

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert Graph from Excel File (2000)

    Dan, take a look at <A target="_blank" HREF=http://www.rdpslides.com/pptfaq/FAQ00067.htm>PP FAQ</A>. That should clear up most things. If there are still problems, reply back and we'll try to fix them. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insert Graph from Excel File (2000)

    Thanks for the link. It gave me some clues but I still have questions.

    The FAQ item 1 says to put the charts on their own chart sheet. That sounds like it is different from a worksheet. I don't know how to do that.

    The FAQ item 3 says to set Tools, Options, Chart, "Chart sizes with window frame" NOT checked. I cannot get this option active (i.e. it is dimmed and not available for change). It is checked on both Excel 98 and 2000.

    Thanks for your help.

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert Graph from Excel File (2000)

    <img src=/w3timages/blackline.gif width=33% height=2>
    > put the charts on their own chart sheet.
    <img src=/w3timages/blackline.gif width=33% height=2>
    There are two fundamental types of charts -- ones "embedded" on a worksheet and ones that are on a sheet by themselves, this sheet is called a chart sheet. To change an embedded chart, use the Chart > Location menu.

    <img src=/w3timages/blackline.gif width=33% height=2>
    > Chart-sizes-with-window-frame is dimmed
    <img src=/w3timages/blackline.gif width=33% height=2>
    Once you make the chart be on a Chart sheet, you will be able to check this option. --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Insert Graph from Excel File (2000)

    Thanks. Everything is clear now and performs as I expect.

    Hope others that may have ventured into this area of using Excel charts in Powerpoint presentations can now proceed with more confidence.

Posting Permissions

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