Prime Number Calculator, Numbers, Mac?

I cannot tell from the examples in your post what bar charts have to do with prime numbers. The only difference I can see is showing the value for the bars.

To show the value for a bar...

select the series in the chart, then use the "Series Formatter":

We're fellow users here. Why be angry? You can communicate with Apple via Numbers > Provide Numbers Feedback in your menu.

The common solution given in Excel to determine whether a number is prime involves array formulas. Numbers doesn't have array formulas, an advanced spreadsheet feature that most people rarely use (though they can be handy for problems such as this).

As for your chart problem, have you tried clicking the chart, then Edit Data References, and then (lower left) Plot Rows as Series?

SG

The Excel array formula wouldn't work in Numbers even if Numbers had array formulas. It relies on the monolithic tables of Excel (you need X-1 rows to test the primeness of number X) whereas in Numbers you make tables the size you need for your information. I have to say it is a clever use of an array formula to make it check for primeness.

You could probably write an Applescript that would run the same algorithm which is basically testing with each and every number from 2 to the square root of X. It would require selecting the cell(s) then running the script. Or you could write a specifically crafted script for your document that would test specific cells without have to first select them.

Numbers does not claim to be an Excel clone, it is an Excel alternative. Use the tool that works best for you, be it Excel, Numbers, or one of the open source clones of Excel.

Glad it helped! It's really easy to miss that toggle switch down in the lower left corner of the window, and even if one sees it there after clicking Edit Data References, it's easy to miss its significance. Thanks for the green tick.

SG