Question

Working with embedded excel table in powerpoint

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

and paste it in the PPT.

VAPCMD

- Collapse -
PIC?

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

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
- Collapse -
More explanation

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.

Maybe in the future there will be ExcelPoint.
Bob

- Collapse -
Following the directions provided is probably the simplest

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

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

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

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

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