kat Posted June 7 Share Posted June 7 Here are a couple tips for getting Excel for Mac charts into Affinity Designer and Publisher Change all chart fonts on Excel Home tab from Windows front Calibri to a font face you use in Affinity. Open chart pdf in AD make changes (like deleting rectangle)>copy Open Apub and place chart from AD. Quote Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1 Link to comment Share on other sites More sharing options...
GarryP Posted June 8 Share Posted June 8 I don’t understand the purpose or expected effectiveness of this thread. Why is it posted in the Questions section of the forums? Are they separate tips or steps in a process? Why does it only concern Excel for Mac? Why does the font have to change? Why is there no information about the export process itself? Why is Designer involved? What is the “make changes” and “deleting rectangle” sentence about? What is the problem being addressed and what is being achieved? Quote Link to comment Share on other sites More sharing options...
thomaso Posted June 8 Share Posted June 8 In addition to Garry: I can simply select a diagram in Excel + copy/paste it on a page in APub. – No need to change a font, delete an object, export as PDF or involve AD. (macOS 10.14.6., APub V1) Quote macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1 Link to comment Share on other sites More sharing options...
kat Posted June 8 Author Share Posted June 8 Posted here, because I had no idea how/where to post elsewhere. This works for me, after many unhappy tries. Excel for mac 2016 charts are not an easy import in Affinity AD & Apub 2.5.2. Copy/paste from Excel into Apub or even AD came in with bad text sizes, while an exported Excel pdf gives me a good place to start. When I place from AD to Apub it's easy to make additional changes by double clicking the layer in Apub. Charts come in from Excel with extra layers with rectangles, masks, e.g.: rectangles with rounded corners comes in with masks over a square corner rectangle. I prefer a tidy file before placing it into Apub. Quote Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1 Link to comment Share on other sites More sharing options...
GarryP Posted June 9 Share Posted June 9 I don’t use Excel so I can’t check the process for myself. It might help if you take us step-by-step through the process, detailing what the problems are at each step and explaining why the recommendations you are giving help you to do what you want. You might like to attach an example Excel file and exported PDF (for those without Excel) so people can see what the problems are for themselves to understand what the tips help to achieve. Quote Link to comment Share on other sites More sharing options...
kat Posted June 9 Author Share Posted June 9 The Excel chart Save as PDF I got from an Adobe expert who uses it to open in Illustrator. I thought tables might be simpler - wrong. Screenshot is what I get when I copy/paste a simple speadsheet from Mac Excel to Apub 2.5.2. I tried to do an Apub table and open a cvs file in Apub. Didn't work. Next I tried copying the Excel file into Numbers, which worked than copy/paste into an Apub table tool. To get to the Apub screenshot below I had to delete lots of extra rows and columns. Maybe I'll have to learn Mac Numbers ; ) I was on another thread and nobody seemed to have great luck importing Excel charts . Quote Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.