linking oval shapes from Excel to PPT

Hi,

Is there a way to link oval shapes from excel to PPT

Presently when I copy the oval shape from excel im not given the option to paste a linked object when I try to paste it into powerpoint

Is it possible to link a shape from excel into PPT?

Thanks
Seamus
Seamus2626Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
What benefit do you want to get by having it linked?

An oval is just a shape. There are obviously properties behind it that affect size, colour etc but nothing that is "linkable".

Are you expecting the shape in PPT to change if the shape in Excel changes?

Slightly tortuous route that you might be able to use:

In Excel make use of the Camera Tool to create an image of the Oval in question and position the resulting image on a blank sheet with gridlines switched off. Then link that area of the sheet to the PPT file.
0
Seamus2626Author Commented:
Basically I have a report in Powerpoint -

I create the graphs and tables and charts in excel, then I copy them, and paste as a linked object in ppt

This means, I refresh my pivots in excel and all my tables/graphs refresh. I update my links in powepoint and boom my report is ready to go.

The oval shapes in excel that I have wont copy over as a link - so it means I have to manually move over the oval shapes.

let me try the camera method

Thanks
0
Rob HensonFinance AnalystCommented:
The Oval is superimposed over the graph so won't be included as part of the graph when copied and pasted.

The camera method would only work there if you copy the whole of the graph area to the camera image. This will then include the Oval. But doing that you might as well link the sheet rather than just the graph. Copy the cell area over which the graph is sitting and paste that as a link, hopefully the Oval will also copy.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.