Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lain_
Contributor III
Contributor III

Sort a Bar Chart Based on One Value

I have a pivot table like the one below. I am graphing this as a bar chart where N, Y are the x-axis, % is the y-axis and each A% and B% pair are the bars. Is there a way to sort this on the x-axis based on the A% value. For instance, here YA% is 0 whereas NA% is 3. YA% would be to the left of NA% on the x-axis on the bar chart. The NB% and YB% values do not matter in this sort.

  %
NA3
 B1
YA0
 B10
10 Replies
lain_
Contributor III
Contributor III
Author