What has been GAINED in the Numbers 3.0 upgrade?

Hi SG,

Here is an interactive Chart, created in Numbers '09 but now irrevocably converted to Numbers 3.0 (I did what I shouldn't, and edited it in Numbers 3.0. Bummer!)

Type a number into Cell A2 of the second table to choose a week.

Formula in Cell B2 of the second table is:

=VLOOKUP($A2,Table 1::$A$2:$H$5,2,FALSE)

Copy Right, but change the return column number to 3, 4, etc.

Document is in my DropBox:

https://www.dropbox.com/s/0i97bcg0kvsf2rt/Screenshot%202013-11-01%2000.44.35.png

Hope this works. Regards,

Ian.

Message was edited by: Yellowbox. Sorry, having trouble uploading Dynamic Chart to DropBox. I think I uploaded just the screenshot.

Hi SG,

Try this for Dynamic Chart in DropBox:

https://www.dropbox.com/s/wezxlg5zqn5zxyk/Dynamic%20Chart.numbers.zip

Regards,

Ian.

Hi SG,

It was created in the old Numbers. It still works after conversion to Numbers 3.0. Happy to hear of any 3.0 enhancements that you can find.

Regards,

Ian

I noticed a significant speed improvement. I took a 7,000 record Filemaker Database and brought it into Numbers 3.0. The previous version of numbers slowed to a crawl with that many rows, but Numbers 3.0 sorts, filters, COUNTIFS, SUMIFS, very quickly. I'm running it on a new MacBook Pro so some of the speed gain might be attributed to that but I doubt much.

While I certainly miss the CATEGORIES feature and the QFX import capabilities of old Numbers, I'm starting to like the new Numbers for its speed improvements.

Hi SG,

and I can start another thread posing a question about interactive charts specifically?

Good idea. Let's keep this thread aimed at your original intention: What has been GAINED in the Numbers 3.0 upgrade.

I have been thinking of starting another thread on changes in functionality (not features) in V3. I have not found any loss of functionality, just new ways of working. We need to learn where things are now in V3 (a bit frustrating at times) but that is just the old dog having to learn where the bone is buried now!

I will have a think about a new 'functionality' thread. I don't want to open yet another complaints department (perceived loss of functionality, because we must now achieve it in a different way).

Regards,

Ian.

Hi ironex,

Good to hear about improved speed and improved ability of Numbers 3 to handle large documents. There have been many discussions in this forum about Numbers 2 getting bogged down with large numbers of records. Let's hope that this truly is an enhancement, and not just your new machine 🙂.

Regards,

Ian.

Hi SG,

Would a separate "workarounds" thread make sense

Yes. Those who are new to Numbers (and don't keep hankering back to Numbers 2) will show how they do things. We old dogs can learn from them.

Good idea.

Regards,

Ian.

Added since last update:

- Easily add or delete items in a pop-up menu using Format Inspector > Cell > Data Format. Reorder items by dragging.

- Powerful real-time editing and sharing via iCloud with any computer that has a recent browser.

- improved speed and improved ability of Numbers 3 to handle large documents. Any comments from users to confirm this?

Previous list:

- Share is now a button. Nice and intuitive.

- Sort the contents of Sheets shown in Sheet tab pop-ups by selecting an object, Arrange > Send Backward or Bring Forward.

- Better cross-platform sharing/collaboration (between OS X and iOS).

- The alignment guides (for moving or resizing objects) remain. See Numbers > Preferences > Rulers.

- New ability to rotate axis labels on graphs (Charts).

- Improved management of custom templates.

- Adding a shadow to a Table is now a workaround. (Hint: slide a shadowed rectangle behind the Table).

- New ability to attach a comment to a Chart (graph), a Shape, or a Text Box (not just to Table Cells).

- New Statistics Pane (Bar at bottom) with many new auto statistics. Click on gear wheel.

- New Bubble charts.

- New Cell Format "Star Rating"

- Function Browser (with definition and examples as in Numbers '09) now appears in the panel on the right whenever you type = in a cell.

- Copy and Paste now carries cell formatting (for example, cell borders) as well as cell content.

- The Colours window remains and works as it did in Numbers '09. Menu > View > Show Colors, or shift command c. The full range of colours remains. Drag a colour from the patch at the top of a palette and drop it into a cell.

- Press Command Right Arrow or Down Arrow to be taken to the last cell, and Shift Command Right/Down Arrow to select all remaining cells in a row/column.

- In addition to Table filtering in the Filter Inspector, there is a basic Filter in the pop-up menu of each Column reference tab. Choose to show only those Rows that contain (in any Column) one of the values listed. More basic than the Filter Inspector, but quick.

- Many more Chart types, including some interactive charts controlled by a slider and buttons.

- Format Inspector > Cell > Data Format > Automatic or Number > Decimals, now allows Auto as well as the previous set number of decimal places.

Regards,

Ian.

Hi SG and Fellow Numbers 3 Users,

In Numbers 2, it was a pain to add or remove Header Rows and Header Columns in a Table without losing cell contents (at least for me).

In Numbers 3, the Contextual Menu (shown when clicking on the disclosure triangle of a Row or Column reference tab) has new powers. Now we can Add Header Row Before (and after, if there is already a Header Row). Similarly with Header Columns.

Regards,

Ian.

Ian,

From Numbers 2.3

Jerry