Pyanepsion Posted December 21, 2020 Share Posted December 21, 2020 Hi to all. Is it possible to directly and quickly create the same pie chart in Affinity Publisher as the one obtained by Excel from a list of numbers? How do I do it? The aim is to obtain a cleaner plot than by importing from Excel. Thank you for your explanations. pie.afpub Quote 6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity Publisher, Affinity Designer, Affinity Photo). ███ Mais je vous le demande, peut-on imaginer une police sans sérifs ? Link to comment Share on other sites More sharing options...
v_kyr Posted December 21, 2020 Share Posted December 21, 2020 There are several ways to create this. Try the Donut/Ring Tool Try the Cog/Gear Tool Samples ... Pie Chart in AD How to divide a circle Dividing a shape ... and so on ... Pyanepsion 1 Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
Pyanepsion Posted December 21, 2020 Author Share Posted December 21, 2020 I am actually looking for a process that is closer to what happens in reality. For example, the customer gives a following price list and it is a matter of obtaining the camembert, as Excel does. 1. 260,44 2. 104,17 3. 104,17 4. 83,34 5. 125,01 6. 364,61 = 1041,74 How to proceed with Affinity Publisher? Quote 6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity Publisher, Affinity Designer, Affinity Photo). ███ Mais je vous le demande, peut-on imaginer une police sans sérifs ? Link to comment Share on other sites More sharing options...
v_kyr Posted December 21, 2020 Share Posted December 21, 2020 35 minutes ago, Pyanepsion said: I am actually looking for a process that is closer to what happens in reality. ... How do you export/import from Excel, as bitmap or as vector (copy/paste, PDF, SVG)? - AFAIK Excel can also export as vectors, either itself in actual versions (or via the help of PowerPoint), or via some MS add-ons (FileFormatConverters.exe, SaveAsPDFandXPS.exe, ... etc.). If you copy the Excel chart into PowerPoint you should be able to export from that as SVG. Afterwards import the SVG into Publisher! Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
Alfred Posted December 21, 2020 Share Posted December 21, 2020 Since Affinity Publisher doesn’t currently have any charting tools, it isn’t possible to “directly and quickly” create a pie chart from a list of Excel data. Pyanepsion 1 Quote Alfred Affinity Designer/Photo/Publisher 2 for Windows • Windows 10 Home/Pro Affinity Designer/Photo/Publisher 2 for iPad • iPadOS 17.4.1 (iPad 7th gen) Link to comment Share on other sites More sharing options...
Wosven Posted December 21, 2020 Share Posted December 21, 2020 I usually used a formula like 360/100*x or similar with the max degres and rotate the resulting pies... With your numbers,I would divide by 1041.74 instead of 100. To be able to enter directly percentage would be great. Another option is to do it first in Excel or similar app, and redraw the resulting graph in a nicer version. Pyanepsion 1 Quote Link to comment Share on other sites More sharing options...
StainX Posted December 21, 2020 Share Posted December 21, 2020 Yeah, i think Publisher/Designer are more about design itself then working with databases, but i would use that approach, like v_kyr said: Edit: If you don't care about the design... save a pdf or svg in excel and import it... Pyanepsion 1 Quote Link to comment Share on other sites More sharing options...
Pyanepsion Posted December 22, 2020 Author Share Posted December 22, 2020 Thank you for all these explanations. I was actually hoping not to have to use Excel to prepare the graph for each value: x=260.44×360 ÷ 1041.74 x=104,17×360 ÷ 1041.74 etc. In short, this could be a suggestion for an extension to quickly reproduce all graphs Excel style. Wosven, Alfred and StainX 3 Quote 6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity Publisher, Affinity Designer, Affinity Photo). ███ Mais je vous le demande, peut-on imaginer une police sans sérifs ? Link to comment Share on other sites More sharing options...
v_kyr Posted December 22, 2020 Share Posted December 22, 2020 Well I think overall that other third party apps are much more specialized and predestinated here for such tasks, like generating different beautiful chart styles out from given data. - And as I said before, you can always import and reuse a vector representation (PDF, SVG) of from other apps generated charts here! You can even generate SVG charts online if needed ... Create a Pie Chart Online chart maker 10 best free HTML & SVG chart generators ... and so on ... Quote ☛ Affinity Designer 1.10.8 ◆ Affinity Photo 1.10.8 ◆ Affinity Publisher 1.10.8 ◆ OSX El Capitan ☛ Affinity V2.3 apps ◆ MacOS Sonoma 14.2 ◆ iPad OS 17.2 Link to comment Share on other sites More sharing options...
Pyanepsion Posted December 22, 2020 Author Share Posted December 22, 2020 OK, but this has nothing to do with an extension. Quote 6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity Publisher, Affinity Designer, Affinity Photo). ███ Mais je vous le demande, peut-on imaginer une police sans sérifs ? 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.