There are preset colour sets for graphs in Apple numbers spreadsheet. It’s easy to apply a preset set of colours for a graph. But how do you customise the individual colours of bars or lines within a graph? This took me ages to work out! The trick is to click on the graph, then click on the bar in the graph, then the style window appears. (It’s usually hidden).
Continue reading ⟩
Today I had a list of full names (eg “Ed Smith”) in a Numbers spreadsheet. I wanted to separate it into first and last name to be able to sort if alphabetically. It was harder than it should be – in my opinion Apple should have a firstname and lastname function! But they don’t. So here’s how to get first name and last name.
Avery has just released a free program designed to be able to print on any of their labels, of course you can use them to print on anything, but they work well with the Avery stuff because you can just type in the number from the packet and it has all the sizes already. It’s a free download from here. I just downloaded it (262 MB!) and it looks pretty good.
Thanks to Paul Sheely for this pointer on how to export from an apple numbers file into the avery application:
1. Export your numbers file as a CSV file (make sure that you’ve made the first line in each column a heading)
2. Download the design pro app from Avery (http://www.avery.com/avery/en_us/Templates-&-Software/Software/Avery-DesignPro-for-Mac.htm)
3. Follow the simple instructions…. you choose a label type… an avery number… a design type… you mail merge your CSV file… and you’re away.
Very simple once you’re set up. The Avery app allows you also to merge directly from Address Book or Mail and you can upload artwork or photos.
Recent Comments