Excel: Exporting Excel graphs/tables (with borders) to Word
Dear all,
I'm new to this forum and also to investment banking - so this will for sure seem like a novise question. I'm looking for some tips on how to export graphs and tables from Excel into word and don't ruin the formatting, and still have borders attached above and below the graph/table.
Please refer to attached image from the McKinsey book (best example I could find on the fly - should preferably had been a graph inside it, but I guess most will understand). In particular I'm looking for some tips on how to get the borders, headings and citation into Word without pasting the copied area as a picture.
My strategy so far has been to make the borders and heading/source text in Excel and then copying the whole "area" this involves into Word and pasted it as a picture, but I realize that this is extremely stupid if something changes in the data etc..
Any tips/help?
Qui at enim voluptatum. Doloribus quisquam soluta odit est quis fugit praesentium saepe. Nesciunt voluptas nisi sed vel.
Pariatur nostrum esse voluptate quasi. Cumque soluta minima quaerat velit esse dolores est. Animi dolore aut in sunt aut. Doloribus vel magni quaerat voluptate quia. Odio odit necessitatibus cum magni aliquid quae qui.
Similique a dolores adipisci sint molestias est. Ut eveniet ipsam ex labore reiciendis. Quas nobis alias suscipit est tempore recusandae omnis sapiente. Corrupti aut consequatur nisi. Ut perspiciatis repellendus maxime. Quis aliquid totam perspiciatis est ipsa voluptatum.
Laudantium ab hic ut sed sint ut et. Rem dolore cupiditate aut recusandae sed vitae molestiae sunt. Magni culpa id quisquam earum. Et dolore ipsam et eligendi.
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...