Skip to main content
Participant
Nov 17, 2026 8:43 AM UTC
Question

Is there a best practice for linking graphs from excel into indesign?

So I have a project where I need to make an asset book with about 40 properties. Every single one of them needs to have at least 2 graphs in their respective visual slide in the book. The data comes from excel. So my question is how do I approach this? Is there a way for me to get the same linked updates as with tables? Or can I use illustrator to get something similar?  

    2 replies

    Participant
    Nov 17, 2026 9:35 AM UTC

    For 40 properties I would keep one master spreadsheet and treat it as the single source of truth, then update the graphs from it rather than editing numbers in each document. A workflow that works well for me is to build each chart once, place it as a linked graphic, and refresh the link when the data changes, so the layout stays untouched. Keeping the file names and sheet names steady helps a lot, since a renamed source is the usual reason a link breaks. It is worth testing the full update round trip on two or three properties first before doing all 40.

    Translate
    Participant
    Nov 17, 2026 10:00 AM UTC

    Prefect. Thanks. So in other words, you have all the data in a spreadsheet, then update the graphs into what, illustrator? Then make the assets from there?

    Translate