How do I create a graph/chart of where customers live from my database which I export to Numbers?

Hi Donald,

Your last question answered first:

These are text fields so I am at loss as to how get the count into a chart.

You can change text into a number with the VALUE function.

Now with number values, the COUNTIF function is your friend. It will count the number of customers per town.

Add another table (Customers per Town). Row 1 is a Header Row and Column A is a Header Column (as required for any Category Chart such as a Pie Chart)

Formula in B2 (and Fill Down)

=COUNTIF(Customers::B,A2)

Now select columns A and B of Customers per Town and insert a pie chart

by how many, and possibly, what percent of the customer base

This Pie Chart has, by default, shown percentages.

You can change the graph (Wedge) values to Number here:

Please reply with questions.

Regards,

Ian.

Have you checked out 'Create and modify charts section' at Help > Numbers Help in your menu?

Also, see the 'Charting Basics' template at File > New in your menu. Some of the examples there may be very close to what you want to do.

SG