Question

Working with embedded excel table in powerpoint

Dec 3, 2013 3:12PM PST

I have an embedded excel table in powerpoint 2007and I need to create a chart based on the data and put it in the next slide.

Is this possible and how do I go about it?

Discussion is locked

Follow
Reply to: Working with embedded excel table in powerpoint
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: Working with embedded excel table in powerpoint
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Comments
- Collapse -
Answer
Create a PIC from the Excel Data Table and
Dec 4, 2013 9:37AM PST

and paste it in the PPT.

VAPCMD

- Collapse -
PIC?
Dec 5, 2013 1:25AM PST

I don't get it. What is a PIC? Is it a type of chart?

- Collapse -
Create the data table, copy it and paste it into an open
Dec 5, 2013 9:06AM PST

part of the worksheet as an IMAGE/PIC(ture). Then copy the pasted image/PIC and paste it into the PPT. Then size the image to fit space....max width is normally 9.5.inches wide.

VAPCMD

- Collapse -
Answer
You can either inser a PICture
Dec 5, 2013 1:40AM PST
- Collapse -
More explanation
Dec 5, 2013 1:28PM PST

I think there has been a mix up. I have a table already embedded/inserted in powerpoint. I created it without opening excel i.e. I inserted the table. Now I want a based on that table. I want to know if it is possible to create that chart still working through power point and get it to show on the next slide.

I know I can copy the data out into excel, create the chart and paste back into powerpoint. i just want to know if I can avoid the middle man.

- Collapse -
Sorry no.
Dec 5, 2013 2:43PM PST

Maybe in the future there will be ExcelPoint.
Bob

- Collapse -
Following the directions provided is probably the simplest
Dec 6, 2013 10:47AM PST

way of capturing and displaying the data behind the CHART. There are probably other ways but that's the simplest and easiest way to do what you asked.

If you find a much better feel free to post it here for the next user with the same problem.

VAPCMD

- Collapse -
Directions
Dec 6, 2013 1:05PM PST

Could you throw more light on this? I don't know what directions you are talking about.

- Collapse -
I misread your post....I read it as you wanted to show
Dec 7, 2013 4:39AM PST

the data behind the chart/table from an existing spreadsheet vice creating a chart/graph from a table in a PPT. To do what you want really depends on how the data table was added or embedded into the PPT.

If it was done one way....you could copy the data as is, the individual entries en masse, put them into Excel and create a CHART or TABLE from there. You should be able to paste or embed that CHART/TABLE back into PPT. If it was just a PIC of a table from Excel ...the you'd have to recreate (type-in) the data. Here are some links on Tables in PowerPoint that might help explain further.

https://www.google.com/#q=powerpoint+with+embedded+table

Let is know how it works out.

- Collapse -
Did it the long way
Dec 8, 2013 8:57PM PST

Like I mentioned earlier, I embedded a chart in powerpoint, then copied out the data from the embedded table and used it as the chart's source data. I did all this throw powerpoint but I have two tables, The visible embedded one and the invisible one behind the chart.

- Collapse -
Ok...Thanks for the outcome. Since I use Excel way
Dec 9, 2013 10:53AM PST

more than PPT ....I'd have done it the other way...used Excel to enter the figures and create the chart...then pop'em both into PPT.

VAPCMD

CNET Forums

Forum Info