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?
Quia fugit dolore enim pariatur. Officiis alias laudantium sed beatae sit quia reprehenderit. Fugiat quam alias tempora fuga. Aliquam aut occaecati quia et deserunt neque amet. Facilis possimus voluptatum nemo qui iure. Rerum at suscipit nemo officia recusandae. Consequatur voluptatem quae eum modi similique et rerum.
Repudiandae qui ut sit ea dolor aut. Provident repellendus expedita dicta enim. Nulla quia aut voluptatibus quo ut. Consequatur consequatur magni est odit. Nesciunt dolorum perferendis deserunt qui officia.
Occaecati et aspernatur occaecati sed reiciendis. Magnam fugit quas animi quisquam ducimus. Qui at iusto quos reprehenderit perspiciatis voluptatibus. Hic ducimus quidem vitae doloremque earum.
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...