Creating a bar chart where data with lower number gets a higher bar

%3CLINGO-SUB%20id%3D%22lingo-sub-2794014%22%20slang%3D%22en-US%22%3ECreating%20a%20bar%20chart%20where%20data%20with%20lower%20number%20gets%20a%20higher%20bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2794014%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20bar%20chart%20that%20shows%20rankings%201%20is%20highest.%26nbsp%3B%20Rank%20goes%20from%201-33.%20I%20want%20the%20highest%20ranking%20to%20have%20the%20tallest%20bar.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2794014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

Screenshot 2021-09-29 at 08.16.37.png

The formula used in column D is as follows:

=MAX([Rank]+1)-[@Rank]