Automatically Copying Data from Excel to Templated Powerpoint Charts

  • Thread starter Thread starter Jim Santa Barbara
  • Start date Start date
J

Jim Santa Barbara

I have a question regarding linking Powerpoint and
Excel. I need to move data from Excel to Powerpoint charts, and I am
wondering if this can be "automated" to a certain extent to alleviate
some of the tedium of the job, because I have to do this many, many
times. Many times. Please help. :)

I need to take data from Excel and put it in Powerpoint charts, and in
a particular chart template. I don't want to make the chart in Excel
and move it to Powerpoint. I do this on a very regular basis, and the
data I start with is in a very similar format every time, and the
charts I import to are in a similar format every time as well. Is
there some sort of Macro that might do this?

I don't know if my question is clear, but any help you can give me
would be greatly appreciated (even if only to tell me "Yes/No" this
is/is not possible). Thanks!
 
Don't quite understand why you don't want to create the charts in XL.

If you do, you could adapt the suggestions I shared in a concurrent
discussion titled "Importing Multiple Excel Charts" in the PP NG.

If not, you would have to automate MS Graph. For an example, see
http://support.microsoft.com/default.aspx?scid=kb;en-us;267974

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Kurt - Thanks for the link.

Tushar - My client insists he wants the charts to be Powerpoint
charts, rather than imported Excel charts. I think the code you
posted links to just copies Excel charts into Powerpoint, which won't
do (clients get there way here LOL).

Thanks to both of you for your help.

-Jim
 
Hi,
The answer with Office is almost always "yes".
There are some questions:
*what version of Office?
*how does the data get into Excel?
*how do you plan to specify in Excel which PPT chart template to use?
*how many different chart templates?

I've created a program which populates PPT slide templates (including chart
slides) from XML data. The advantage of XML over Excel is that XML is
highly structured.

Chris
 
Powerpoint & Excel 2002

Data gets saved to Excel from an SPSS dataset. I just save a subset
of my bigger database into Excel, and then copy and paste from there.

I don't really know how I would specify the PPT chart template to use.

As far as different chart templates, probably about 10 different types
of charts - some line graphs, some stacked bar, some with multiple
charts per page.

I'm sorry, what is xml data? Can Excel data just be saved as XML
data? If so, maybe your program would be useful for me.
 
Jim-
Can I ask your reason for not creating the graphs in XL and exporting to
powerpoint?
Personally, I find it easier to automate graph functions in XL and copy them
over; to make it as simple as possible I've then automated the
copying/pasting of graphs, Excel ranges, etc to Powerpoint, including
resizing and anything else that needs to be done. For one workbook (used by
other folks I work with), I put together a userform in XL so they could
select what to copy over to powerpoint (essentially a menu of different
graphs and ranges). All very automated. I'd be happy to send you a sample or
give suggestions on additional automation if you are interested in trying
this approach.

In terms of overall automation, I've had projects where (in XL) I'll set up
the basic graphs, maybe 40 total, then continually re-populate them with new
data sets, and export the output each time to a new file, or pdf format, or
powerpoint. If you are repeating the same format with new data multiple
times, this is easy to do in excel. Perhaps moving the discussion over to
microsoft.public.excel.programming would get you a wider variety of options
as well.

Chris- I haven't done so much with XML- are you taking data directly into
Powerpoint graphs from XML? If so, could you post a simplified code snippet
to show how you pull it as the source for the graph(s)?
 
There's no such thing as a PP chart. PP uses MS Graph.

My guess is that MS Graph and XL's charting module share (or shared)
the same source code base.

In any case, my first post had a link on automating MS Graph.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top