Yana Burmistrova
asked on
VBA (Excel graph to Power Point)
Dears,
First of all i would like to thank you for reading my question!
I am really Need in your help!
i have two Graphs in Excel Document (they are in different sheet-Sheet 1.Sheet 2)
Could you please let me know how can i create a button and by clicking this button to add this two grapghs in ONE Power Point Document, in one presentation (automatically)?Whats Code in VBA do i Need to write for solving this Problem?
Thank you so much a lot of times in advance!!!
Excel-VBA.xlsx
First of all i would like to thank you for reading my question!
I am really Need in your help!
i have two Graphs in Excel Document (they are in different sheet-Sheet 1.Sheet 2)
Could you please let me know how can i create a button and by clicking this button to add this two grapghs in ONE Power Point Document, in one presentation (automatically)?Whats Code in VBA do i Need to write for solving this Problem?
Thank you so much a lot of times in advance!!!
Excel-VBA.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Recent versions of PowerPoint save the Graph data in an excel file.
if you recreate the graph in Powerpoint when you get to select the data you can just copy and paste the data from Excel or maybe link to the data in your existing worksheet.
Thanks
Rob H
if you recreate the graph in Powerpoint when you get to select the data you can just copy and paste the data from Excel or maybe link to the data in your existing worksheet.
Thanks
Rob H
ASKER
Unfortunately,its no exactly what i Need....
ASKER
I Need to press on the button,and automatically move all Graphs from one Excel document(Even from different Sheets)to one power Point presentation ...
Yeah, the one button will be on opening the file. There will be a warning asking whether to update links, click Yes.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split:
-- Thommy (https:#a41821235)
-- Thommy (https:#a41821247)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Split:
-- Thommy (https:#a41821235)
-- Thommy (https:#a41821247)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer
ASKER