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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Make a Ranking Chart In Numbers?
Comments: 3 Responses to “How Do I Make a Ranking Chart In Numbers?”
Comments Closed.
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.
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.
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.