SOLVED

How to sort multiple graphs in order highest to lowest from the same data set?

%3CLINGO-SUB%20id%3D%22lingo-sub-1492197%22%20slang%3D%22en-US%22%3EHow%20to%20sort%20multiple%20graphs%20in%20order%20highest%20to%20lowest%20from%20the%20same%20data%20set%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492197%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20probably%20really%20simple%20but%20I%20can't%20seem%20to%20find%20a%20way%20to%20do%20it%20and%20can't%20seem%20to%20find%20the%20right%20answer%20on%20Google.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20have%20a%20table%20with%20mobile%20usage%20i.e.%20minutes%20used%2C%20sms%20sent%2C%20data%20used%20etc.%20I%20currently%20have%20two%20tables%20one%20is%20'Top%2010%20data%20users'%20and%20the%20other%20'Top%2010%20callers'%20basically%20one%20showing%20users%20with%20highest%20data%20usage%20and%20the%20other%20with%20highest%20minutes%20usage.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20sort%20the%20data%20usage%20column%20highest%20to%20lowest%20my%20graph%20looks%20fine%20but%20then%20I%20also%20want%20my%20second%20graph%20to%20be%20ordered%20highest%20to%20lowest%20but%20I%20can't%20because%20I'm%20already%20sorting%20the%20data%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20without%20having%20to%20duplicate%20the%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20screenshot%20so%20it's%20easier%20to%20understand.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKamil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492197%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%3CLINGO-SUB%20id%3D%22lingo-sub-1492227%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sort%20multiple%20graphs%20in%20order%20highest%20to%20lowest%20from%20the%20same%20data%20set%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492227%22%20slang%3D%22en-US%22%3EIts%20better%20you%20use%20Pivot%20Charts%2C%20which%20works%20easier%20with%20data.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20share%20the%20sample%20file%2C%20and%20we%20could%20help%20you%20with%20the%20example%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492231%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sort%20multiple%20graphs%20in%20order%20highest%20to%20lowest%20from%20the%20same%20data%20set%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492231%22%20slang%3D%22en-US%22%3E%3CP%3EIts%20better%20you%20use%20Pivot%20Charts%2C%20which%20works%20easier%20with%20data.%20You%20can%20share%20the%20sample%20file%2C%20and%20we%20could%20help%20you%20with%20the%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492415%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sort%20multiple%20graphs%20in%20order%20highest%20to%20lowest%20from%20the%20same%20data%20set%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492415%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697164%22%20target%3D%22_blank%22%3E%40SupreethGuptha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorks%20perfectly%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492435%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sort%20multiple%20graphs%20in%20order%20highest%20to%20lowest%20from%20the%20same%20data%20set%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597699%22%20target%3D%22_blank%22%3E%40KamCMM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20helper%20table.%20Idea%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.xelplus.com%2Fexcel-da-dynamic-sorted-chart%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.xelplus.com%2Fexcel-da-dynamic-sorted-chart%2F%3C%2FA%3E%2C%20that's%20with%20dynamic%20arrays%20Excel%2C%20but%20on%20older%20one%20could%20be%20done%20as%20well%20by%20other%20technique.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys,

 

It's probably really simple but I can't seem to find a way to do it and can't seem to find the right answer on Google. 

 

Basically I have a table with mobile usage i.e. minutes used, sms sent, data used etc. I currently have two tables one is 'Top 10 data users' and the other 'Top 10 callers' basically one showing users with highest data usage and the other with highest minutes usage. 

 

If I sort the data usage column highest to lowest my graph looks fine but then I also want my second graph to be ordered highest to lowest but I can't because I'm already sorting the data column. 

 

Is there a way to do this without having to duplicate the table?

 

I have attached a screenshot so it's easier to understand. 

 

Many thanks,

 

Kamil

4 Replies
Highlighted
Best Response confirmed by KamCMM (New Contributor)
Solution
Its better you use Pivot Charts, which works easier with data.

You can share the sample file, and we could help you with the example
Highlighted

Its better you use Pivot Charts, which works easier with data. You can share the sample file, and we could help you with the example

Highlighted
Highlighted

@KamCMM 

You need helper table. Idea is here https://www.xelplus.com/excel-da-dynamic-sorted-chart/, that's with dynamic arrays Excel, but on older one could be done as well by other technique.