Home

Chart demonstrating ranking

%3CLINGO-SUB%20id%3D%22lingo-sub-854231%22%20slang%3D%22en-US%22%3EChart%20demonstrating%20ranking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854231%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20plot%20some%20data%20on%20a%20chart%20to%20show%20the%20trends%20of%20how%20popular%20programmes%20have%20been%20over%20the%20past%20three%20years%2C%20I%20have%20the%20ranking%20of%20those%20in%20the%20top%20twenty%20across%20the%20university%20(only%20some%20of%20which%20sit%20in%20our%20department)%20and%20have%20entered%20the%20ranking%20number%20into%20an%20Excel%20table%2C%20however%20when%20I%20convert%20this%20to%20a%20chart%20it%20ranks%201%20as%20the%20lowest%20whereas%20I%20want%20this%20to%20appear%20as%20the%20highest.%20I%20have%20tried%20Format%20Axis%20-%20Values%20in%20reverse%20order%20but%20this%20just%20puts%20the%20X%20axis%20at%20the%20top%20but%20keeps%20the%201%20as%20the%20smallest%20bar.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated!%20Please%20see%20screenshots%20of%20my%20data%20and%20chart%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131683i39BFE7C10790A926%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131684iAA2A0F1F4C72B208%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854231%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854326%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20demonstrating%20ranking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854326%22%20slang%3D%22en-US%22%3ESo%20you%20need%20a%20larger%20bar%20for%20the%201's%20than%20for%20the%202's%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-854351%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20demonstrating%20ranking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854351%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20as%20the%20number%20one%20is%20first%20place%20so%20better%20than%20the%20others%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
rshreeve
New Contributor

I am trying to plot some data on a chart to show the trends of how popular programmes have been over the past three years, I have the ranking of those in the top twenty across the university (only some of which sit in our department) and have entered the ranking number into an Excel table, however when I convert this to a chart it ranks 1 as the lowest whereas I want this to appear as the highest. I have tried Format Axis - Values in reverse order but this just puts the X axis at the top but keeps the 1 as the smallest bar. 

 

Any help would be appreciated! Please see screenshots of my data and chart below

 

clipboard_image_0.png

clipboard_image_1.png

 

3 Replies
So you need a larger bar for the 1's than for the 2's?

Hi Jan,

 

Yes, as the number one is first place so better than the others

 

@Jan Karel Pieterse 

@rshreeve 

Please find the attached with a sample chart for a simple data set.

I inserted a helper column which replaced the actual series (Actual Rank Column) and to do so, right click on Chart and choose Select Data and in there edit the existing series with the helper column.

And then format the data labels and choose Value From Cells and select the actual rank data.

 

See if you can incorporate this approach to your chart.

 

Related Conversations