If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Several Charts to a PowerPoint Presentation
I'm having a problem regarding linking several Excel charts and tables
from a single Excel file into a PowerPoint Presentation. Example: I create a chart on tab #1 of the Excel file and paste-link it into slide #1 in the PowerPoint file. Then I copy the tab (and call it tab #2) in the same Excel file but change the data and paste link the chart on tab #2 of the Excel file into slide #2 in the PowerPoint file. Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . . Now lets say I update the data in the chart on Tab #2 in the Excel file and go to PowerPoint to update it. It will now convert all the charts in the PowerPoint file to the chart on tab #2. It seems when I update the links, whatever tab is showing (in this case the chart on tab # 2) on screen in the Excel file will then be reflected in every link in the PowerPoint file. It's as if it ignores the links to the designated spread sheets and simply looks to the Excel file to see what it currently looks like. Am I doing something wrong? Do I actually have to create and format a brand new chart on a brand new tab everytime I want to link multiple charts. Copying tabs but individually linking them seems like it should work. If it's of any help, both PowerPoint and Excel are XP versions. Any help would be greatly appreciated. Thanks! JRPK |
#2
|
|||
|
|||
Linking Several Charts to a PowerPoint Presentation
I had the same problem.
There is no simple answer. I had to make a separate excel file for each chart. That way it look at the top sheet for each specific chart. You can't do it in one workbook. "JRPK" wrote in message om... I'm having a problem regarding linking several Excel charts and tables from a single Excel file into a PowerPoint Presentation. Example: I create a chart on tab #1 of the Excel file and paste-link it into slide #1 in the PowerPoint file. Then I copy the tab (and call it tab #2) in the same Excel file but change the data and paste link the chart on tab #2 of the Excel file into slide #2 in the PowerPoint file. Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . . Now lets say I update the data in the chart on Tab #2 in the Excel file and go to PowerPoint to update it. It will now convert all the charts in the PowerPoint file to the chart on tab #2. It seems when I update the links, whatever tab is showing (in this case the chart on tab # 2) on screen in the Excel file will then be reflected in every link in the PowerPoint file. It's as if it ignores the links to the designated spread sheets and simply looks to the Excel file to see what it currently looks like. Am I doing something wrong? Do I actually have to create and format a brand new chart on a brand new tab everytime I want to link multiple charts. Copying tabs but individually linking them seems like it should work. If it's of any help, both PowerPoint and Excel are XP versions. Any help would be greatly appreciated. Thanks! JRPK |
#3
|
|||
|
|||
Linking Several Charts to a PowerPoint Presentation
Hi,
With www.take-off.as/datapoint you can create live graphs linked to excel data (and databases) in a PowerPoint presentation. Kurt "Bruce Yanulavich" wrote in message ... I had the same problem. There is no simple answer. I had to make a separate excel file for each chart. That way it look at the top sheet for each specific chart. You can't do it in one workbook. "JRPK" wrote in message om... I'm having a problem regarding linking several Excel charts and tables from a single Excel file into a PowerPoint Presentation. Example: I create a chart on tab #1 of the Excel file and paste-link it into slide #1 in the PowerPoint file. Then I copy the tab (and call it tab #2) in the same Excel file but change the data and paste link the chart on tab #2 of the Excel file into slide #2 in the PowerPoint file. Copy that tab, change the data and ditto for tabs #3, #4, #5, etc. . . Now lets say I update the data in the chart on Tab #2 in the Excel file and go to PowerPoint to update it. It will now convert all the charts in the PowerPoint file to the chart on tab #2. It seems when I update the links, whatever tab is showing (in this case the chart on tab # 2) on screen in the Excel file will then be reflected in every link in the PowerPoint file. It's as if it ignores the links to the designated spread sheets and simply looks to the Excel file to see what it currently looks like. Am I doing something wrong? Do I actually have to create and format a brand new chart on a brand new tab everytime I want to link multiple charts. Copying tabs but individually linking them seems like it should work. If it's of any help, both PowerPoint and Excel are XP versions. Any help would be greatly appreciated. Thanks! JRPK |
#4
|
|||
|
|||
Linking PowerPoint data into Excel has many limitations. A good tool that may work for you is xpport. It reads your print areas and therefore can copy multiple tables and charts from multiple sheets in your xls file to PowerPoint with a single click. Let me know how it works for you.
Rich Quote:
|
Thread Tools | |
Display Modes | |
|
|