Forum Discussion
Creating a bar chart where data with lower number gets a higher bar
I am creating a bar chart that shows rankings 1 is highest. Rank goes from 1-33. I want the highest ranking to have the tallest bar. Is this possible?
1 Reply
magsm I guess you need to add a column to your table that calculates the size of the bar. Thus, rank 1 will get a value of 33. Then build the bar chart from the "bar value2, not the actual ranking. I have attached a small example.
The formula used in column D is as follows:
=MAX([Rank]+1)-[@Rank]
