Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Sorry for this newbie question:

I want to do something like in a column there are numbers 0.2, 0.3, 0.2, 0.4,

0.2 occur 2 times, whereas 0.3 and 0.4 occur once, I want to make make histogram that first bar show 0.2, the y value will be 2, and 0.3, 0.3 only 1

enter image description here

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Here is one way.

Step 1

  • Make a new sheet.
  • Make a table with one column and add your data to that column:

0.2 0.3 0.2 0.4

  • Make sure that this first table does not have a header column or a header row.

Step 2

  • In the same sheet as the first table, make a new table with two columns.
  • Give that table four rows (or more).
  • In the new table, make the first column a header column.
  • In that first column add in a list of values you want to 'count' on, e.g.:

0.1 0.2 0.3 0.4

  • In the second column, enter this formula in the first row =COUNTIF(Table 1 :: $A$1:A$4,A1) where 'Table 1 :: $A$1:A$4' is referring to the column of data in the first table, and 'A1' is referring to the cell in the first row of the first column in this second table.
  • Copy down the formula to the remaining rows in the second column of the second Table.

You should end up with the second table looking something like:

0.1 0

0.2 2

0.3 1

0.4 1

Step 3

  • Select the second table and click the Charts icon in the toolbar.
  • The first chart type (vertical bar chart) should be what you need. You can then use the Inspector to change the design of the chart.

Hope this helps. See the screen grab as that might help more.

Numbers document showing simple chart set up

share|improve this answer
    
Thanks for adding the formatting. I shall take more care next time. Sorry. –  gentlemanhog Oct 6 '12 at 15:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.