+ Reply to Thread
Results 1 to 3 of 3

While Inserting Chart, need small box which has excel cells but not complete excel file

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    Question While Inserting Chart, need small box which has excel cells but not complete excel file

    Hi,

    Please help me with the below requirement. I'm unsure whether it can be done.

    While inserting any chart in PowerPoint, an excel file is generated where-in we gotta fill in the data. However, I would like to know whether there is any way, where-in I can get a small box of excel cells where I can fill in data and get the chart.

    And if I want to update data for that chart, if I double click the chart, the same box of excel cells should be shown. So that I can edit update the data, resulting which the chart gets updated.

    Any help greatly appreciated.

  2. #2
    Registered User
    Join Date
    11-25-2013
    Location
    Western Australia
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: While Inserting Chart, need small box which has excel cells but not complete excel fil

    If you right-click the chart and select "Edit Data", the original Excel data will open and allow you to edit the values. PowerPoint uses Excel for its charts, so I don't think there's any way around having the Excel window opening.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: While Inserting Chart, need small box which has excel cells but not complete excel fil

    To avoid using excel charts in powerpoint you would have to revert back the insertng the old MSGraph object.
    Cheers
    Andy
    www.andypope.info

+ 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. Automate percentage complete in an Excel Gantt chart
    By brndtaylor in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-04-2013, 10:00 PM
  2. How to link complete sheet of an excel file?
    By mridulaparihar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-24-2011, 07:01 AM
  3. Replies: 2
    Last Post: 03-12-2009, 04:23 PM
  4. Export Excel File as a Complete Entity
    By pianoman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2006, 07:44 AM
  5. Update complete excel file online
    By Philipp Andre in forum Excel General
    Replies: 0
    Last Post: 11-03-2005, 10:00 AM

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