Posting Exel Graphs in PPT
Which of the paste special options is usually used to paste exel-graphs etc in ppt, i.e. 'mcirosoft office grapic object', 'mcirosoft office chart object', or 'picture enhanced metafile'? Is there a standard?
Banks use their own special add-ins which facilitate linking in Excel charts and tables to PPT.
However if you're using stock Excel I like the "Copy As Picture" button in Excel which you can add to your Quick Access toolbar. You can choose to print as on the screen or as shown when printed (I like the second option). You then can just CTRL+V in PPT. It seems to play nicer than enhanced metafile which is my backup.
I usually Insert > Embed excel Chart, so I always have a working template that auto updates.
BTW, anyone know who banks XILINX, or AMD? Trying to get a biscut
Can you recreate the graph in PowerPoint?
This. I either make it in PPT or paste as picture from excel. Embedded charts weigh down the file and really don't add functionality IMO.
You can insert an excel range as a PPT table by Copy Pasting the range into the PPT. Then if you want to preserve formatting, you can hit ctrl+k to paste with formatting. Then, you will have a PPT table that has the same formatting as the excel range. Useful for when you just want to format in excel and then convert over to PPT but as a regular table.
Though to update, you have to update the excel file and then re-paste.
Don't all banks have a plugin for this? Ours is CapIQ
If you have the CapIQ plug-in, I would recommend using that. I think its the most efficient imo
I usually prefer to create the graph in PPT and copy the data from a separate excel backup as it makes it easier to reuse pages in different decks. When you copy the graph itself, your deck is now linked to your excel which creates issues should you ever lose the excel file for any reason.
Reprehenderit esse rerum quas. Dolorem nemo dolorem ut magni voluptates consequatur.
Quia omnis consectetur ad. Natus ab repellendus sunt vero aut quibusdam. Pariatur repudiandae nemo quisquam labore.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...