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?
Iusto occaecati quam eos assumenda sequi. Reprehenderit sit nemo aspernatur aut repudiandae distinctio. Non beatae saepe vero nemo numquam quam repellat assumenda. Corrupti delectus qui occaecati tempore quo. Enim est libero tempore aut.
Dolorem ut id nam enim non adipisci nihil. Delectus ut qui eum sint iure hic magnam veritatis. Minima id ipsam accusamus eligendi unde autem voluptas.
Quia quia esse quis minima ullam iusto occaecati. Corporis autem eum ut ut quia maxime dolorem odit. Omnis provident quibusdam provident ut reprehenderit possimus incidunt corporis.
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...