MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Make a Ranking Chart In Numbers?

I have a column with values, for instance 2 – 1 – 4 – 3 – 5 , and would like to show this in a chart. However, the values reflect a ranking, so I would like ‘1’ to be shown as the highest value and ‘5’ as the lowest in the chart. Any suggestions?.
—–
Jan E. Wille

Comments: 3 Responses to “How Do I Make a Ranking Chart In Numbers?”

    2 years ago

    I’m not sure what sort of chart you are trying to make here. A “column” chart?

    Assuming that is what you want, I would put the values 2, 1, 4, 3, and 5 in the first column of the table. Then in the second column I would put the formula =5-A1 into cell B1 and then copy and paste that into the other B-row cells. Actually =6-A1 may be better since it gives a little height to the 5th rank.

    Then select rows A and B and create a column chart.

    Jan E. Wille
    2 years ago

    Thanks. Visually this sort of works, but if I want to show the values, I get the B column values and not the actual ranking values in column A.

    2 years ago

    You can do that. Just play around with the Format, Axis, Category Labels. You may need to create a third column with labels for each one, but you may be able to do it with just the 2 columns.

Comments Closed.