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?”

    10 months 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
    10 months 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.

    10 months 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.