Try copy from Excel to illustrator, and apply the fonts , then copy from AI to Indesign.
Make sure to apply the fonts in AI because when you paste in indesign the fonts it convert to outline.
Do the formatting in Excelall of it. Copy the chart and then paste into
Otherwise, paste to Illustrator and tweak there. Save as AI and place that
into InDesign DO NOT COPY it from Illy. It will be too complex.
Would i be able to format it in Excel (or illustrator) then place it INdesign so it is linked?
The numbers will be updated daily & people who known even less about Indeisgn than I do will be trying to update it!
I can work out how to place tables (by selecting the appropriate cells in the spreadsheet) but not sure about grpahs.
Thanks for your help
If that's the case my suggestion is to format the graph in Excel, make a PDF
of it, and place that in InDesign. The PDF link can be updated daily.
Thanks Bob, I'm going to give it a shot