Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

moving excel graphs and data to Powerpoint

Posted on 2011-09-09
13
Medium Priority
?
447 Views
Last Modified: 2012-05-12
Hi All,

I need some help with moving multiple graphs and data tables from excel to PowerPoint.  I have an excel file that has a couple of charts and tables on each tab that I need to move specific charts to specific slides and location within PowerPoint. (and data tables).  I have to do this every month and it is a lot of work, so I was hoping someone could help me with a macro.  I think the difficult part is the placement of the graphs and data tables within each slide.  

Thanks,
Montrof
0
Comment
Question by:montrof
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 2000 total points
ID: 36512427
I have this excel file that should be able to help you. I haven't used it in a while but it should be relatively self-explanatory.

T


Transfer-XL-to-PPT---Activity-Re.xls
0
 
LVL 1

Author Closing Comment

by:montrof
ID: 36512431
This is perfect Thanks
0
 
LVL 1

Author Comment

by:montrof
ID: 36512491
I do seem to get an error when i runt he macro . it says -2147188160 Method "Item' of object 'Slides' failed: Slide3
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:montrof
ID: 36512511
Also How do I figure out the size and position in ppt so I can replicate that?
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512696
to figure out size and position, you can run a macro in powerpoint like this

Sub asdgfasdg()
Dim shp As Shape

For Each shp In ActivePresentation.Slides(1).Shapes
    Debug.Print shp.Left
    Debug.Print shp.Width
Next

End Sub

Open in new window

0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512703
are you getting the error on the first transfer? What line of the macro?

T
0
 
LVL 1

Author Comment

by:montrof
ID: 36512745
Yes I get an error just about every time, It still seems to run.
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512760
Still does the job?
What line does the error comes at (if you click debug)
0
 
LVL 1

Author Comment

by:montrof
ID: 36512773
Does not give me the option to debug just hit ok.  Also when I run the ppt macro you provided where do I see the results.
0
 
LVL 1

Author Comment

by:montrof
ID: 36512825
Also what about the hieght of the graph because I ran the debug and took the exact values and it does not match what I had before.
0
 
LVL 39

Expert Comment

by:nutsch
ID: 36512831
in the immediate window (Ctrl+G in the visual basic editor)
0
 
LVL 1

Author Comment

by:montrof
ID: 36513271
One more question when I run the code to see the position size and so forth. It just gives me values but I do not know what they relate to or which shape on the slide they pertain to.
0
 
LVL 1

Author Comment

by:montrof
ID: 36528944
IF I wanted to take the macro and control toolbox sheet and insert it into a workbook, how would I change it so you do not need to input the excel path and instead just use the active workbook.
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question