Excel in Powerpoint question

[Morety]

I have an excel chart embedded into a powerpoint presentation.

The powerpoint is showing many extra rows to the right and along the bottom, resulting in a lot of white space where I do not want it.

How do I detail the actual range of the excel sheet that I want showing on the powerpoint?

ie I want a1 - e7, but it's showing a1 - k50

[Ivyrielle]

Can you set up the print area? Does that work?

[Morety]

That didn't work.

What I did, was copied the area I wanted, pasted it onto the same sheet, then deleted the first one.

That worked.

So I'll just have to copy/paste any revisions I make that involve size.

[Ivyrielle]

One of the gaming books i designed had 80,000 stat cards that all started out in excel spreadsheets. I decided that rather than having to import each and every damn one of them into tables, I'd turn them into graphics. Style in excel, convert to pdf, open in Photoshop, trim, save as tiff.

Haxxor excel ftw!

[Morety]

I usually do my stuff in excel, copy the range, then "paste special" "picture". It saves a ton of room on the ppt document itself.

But in this particular case I'd creating a template for everyone to use, and want them to be able to double click, add the numbers into the spaces and save it.

I know there's a proper way to detail the range I want showing on the .ppt sheet, I just can't for the life of me figure it out.

In the meantime, if I copy it and paste it it works. I then delete the original excel sheet. If I delete the sheet before I paste, it pastes in as a table and not an excel sheet. But, anyhoo...