I've got the following problem:
I need to order my values in bar chart from the highest to lowest:
I know that i can use pivot table and pivot chart, but it could be a bit complicated in the future.
2 Answers
Mine worked, but needed to change the reference to E2 to D2. Unsure if there is an error above...
3.Column E: Lookup each of the values in the order column using a combination of MATCH and INDEX, for example: =INDEX($B$2:$B$16, MATCH(**D**2, $C$2:$C$16, 0))
Related