-
Things may have moved on but I used to do this full time... if you are asking what I think you are asking, the main procedure was something like:
Find out the sizes in cm of your content areas in PPT.
Draw a rectangle/set of rectangles in Excel that correspond to these sizes. Set their properties so they don't move or size with cells, and colour bright pink outline, or something for visibility, no fill
Wrangle your Excel content so it fits inside the rectangle. (For a chart you can just directly set size properties, though)
Copy Excel content, paste as picture at 100% in PPT. Sometimes you might need to prepare larger in Excel and paste at smaller size, if you do this it's a lot easier to stick to simple size ratios.
If you need to stick to colour palette, fonts etc, get it right in XLS first
Outsource to a lower cost country
I can probably give more advice if there's a specific issue.
You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
chez_jay
@Chalfie
So you spend a fair bit of time working out how to do some lovely traffic light visualisation using conditional formatting in excel. I don't know either.
But now it comes to MOVING IT INTO POWERPOINT.
how do you keep it looking nice, how do you set the size and limits and all that?