Dai555

@MikeTO Cheers

Thinking of signing up Cheers Dai

Greaf movie thanks for that.

The free down load I got seems limited to Pie and bar charts. Here is a hollow pie chart. Make sure the A at the end of your numbers is coloured white. Don't forget to create assets out your charts for mock ups and templates. Hollow Pie.afpub

Niether did I till I got a reply from Affinity when I asked them to add this as a feature in Publisher.

`Thank eff for that thought my number pad was playing up. Cheers Guy's

On my lap top I cant change the studio settings with the number pad on the left. Yes the number pad is on and all the page zoom short cuts work fine. The number keys that run across the top of my keyboard work fine, studio changes no problem. It's just the number pad on the right of the key board that's not working. Not sure if this is a bug (don't think so) or it's my key board. Anyone else having similar problems or have any suggestions.

Here is a rough and ready tutorial on how to use chartwell font in Publisher to create graphs. see the attached file. Chartwell Graphs.afpub Chartwell.mp4

Got it working using the glyph browser. It doesn't work with every character though. What I did was to place the small square dot from the Glyph Browser in a text box then cut it and replace the round dot in the style with the square one. Where I have been going wrong is using the wrong size square dot. The larger ones come out as just an outline shape the smaller one comes out as the square dot.

I created a menu with square dots for the tabs. This was a while back and for the life of me I can't figure out how to recreate it. Can you guy's tell how to do it. It would be most appreciated Thanks Dai Square Tabs.afpub

Pie Charts in AFFINITY Publisher - Designer.mp4

@anto shall give it a try and see how it goes. Cheers for the input. Got it working not sure if it's unique names and explicit locations in pages in Data Merge which is working, I suspect both. Plus the master Page had to be detached as it didn't reproduce properly after Data Merge.

So the limitation is label names. from different sources makes a clash in the program rendering it useless for things that have repetitive data labels such as a catalogue. To achieve it only a single sheet from an xslx can be used. I can't see how you can have unique names for things like Item, price,reference, By the time you get to the third or fourth sheet Labels would start being totally unrecognizable. Defeating the object of having well organised Data. I do hope Affinity are going to improve the Data Merge in the future. It makes more sense to do what I want to do in the way I want to do it than have a spaghetti Data source just to get the thing to work for certain applications. Rant over. Thanks for the help lads it's been very helpful.

Is this what you mean Walt if so still not working.

I think I get what you mean. But this is suppose to resemble a catalogue style brochure. Imagine doing the argos catalogue with unique names. The mind boggles. @walt.farrell cheers!

Done all the updates still not having any joy with the second sheet. If you would take a look and tell me what I'm doing wrong it would be appreciated. Brochure.7z

Cheers @walt.farrell

How do I go about using an xlsx data source using more than one sheet as a data source in one document? I'm creating a brochure as test document. and I want to use four sheets in an xlsx as my data source. I've created the first page and data works pulling data from sheet 1. But how do I pull Data from sheet 2 on to another page? Have I got to repeat the data source every time I want to use a different sheet on another page in my document? Every time I change the data source as new sheet in the new page the old page adopts that sheet name/number of the new sheet. for instance first sheet is called rings and works OK on the first page of the document. SeNecklace instead of cond page of document I want to use same Data Source but the Necklace sheet. As soon as I change the Data Source in the Data Merge manager to reflect the different sheet of the xslx Data the first page adopts the new sheet. Both DataMerge grids show Necklace instead of one rings and the other Necklace. So do I load the same Data Source into the Data Manager twice to use one sheet for one page and another sheet for the other page?