Making an output page

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.

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

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