Guys,
I have an excel model with about 15 tabs. Graphs, numbers etc. I want to simply create a different workbook which will have all the graphs on one page. I know you can just copy/paste them. However, I want the graphs to automatically update if the information in the original workbook is changed.
Is there a way to do this?
Thanks in advance.
| +341 | Evercore Intern Seizure | 53 | 8m |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 27 | 1h |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 3h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 1h |
| +30 | How do I understand vs. just memorizing? | 5 | 1h |
| +27 | Which groups are ideal for laterals? | 12 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Reference all required source data for the graphs in cells in the new workbook. Create graphs from new cells (ie the ones that refer to the original workbook) Select all cells in the new workbook and open number formatting. Select custom and input ';;;' without quotation marks if required, to hide
Alternatively just do the above in the same workbook but hide all other sheets
I don't have Excel open but this should work
Yeah just link the data to the output tab, then you got everything there to recreate the graphs and sheet. Can even do it straight from the other stuff but it will be messier I think
Thanks for the reply @"madepicson"
Is there any way to link to these in a powerpoint? For example, can I copy the excel graph from excel and link to it in a powerpoint file, but if I change the values in excel they will automatically update in powerpoint as well? Instead of having to copy/paste and re size the graph every time I make a change.
Thanks for your help.
That was incredibly helpful. Thank you. This is for a middle market firm.
ICG Tools is what we use. Allows for exactly the type of thing you're trying to do. For what I've learned is you copy the cells that contain the graph/chart/whatever in excel, go to powerpoint and there should be an insert excel table and click that and you're good
Link?
IDK It's just some software that we use to make charts in excel. Then all you have to do is import the chart to powerpoint and if you want to update you refresh links.
Just copy and paste the graph into PowerPoint once and select update source automatically through Options or do it manually by right clicking the graph or via the ribbon. Newer versions of Office support this natively/out-of-box
FactSet has an excel add in function to link excel to powerpoint
Aut dignissimos fuga qui qui eum aut. Nihil temporibus aliquid accusantium omnis ad quod neque. Hic consequuntur ullam voluptas laudantium dicta voluptatum. Et delectus qui dolor ullam perferendis voluptatem praesentium perspiciatis.
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...