Jump to content

Tips for importing Excel for Mac charts into Affinity Designer and Publisher


Recommended Posts

Here are a couple tips for getting Excel for Mac charts into Affinity Designer and Publisher

  1. Change all chart fonts on Excel Home tab from Windows front Calibri to a font face you use in Affinity.
  2. Open chart pdf in AD make changes (like deleting rectangle)>copy
  3. Open Apub and place chart from AD.

Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1

Link to comment
Share on other sites

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?
Link to comment
Share on other sites

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)

macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1

Link to comment
Share on other sites

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.

Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. Screenshot2024-06-09at8_57_14AM.png.f7e1eec3e125ff68ff077b1fec752e97.pngNext 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

image.png.120f9d66037ea54d4991fe94a26773b8.png

Affinity Suite v2.5, Mac Mini M2 Pro 2023, Sonoma, OS 14.1.1

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.