Hi,
I have got a sheet with 3 columns a text with a value and a rank. I want to create a chart showing the bars ordered by the rank, that I don't want to see on the chart, keeping the sheet ordered by Column A
Hi,
I have got a sheet with 3 columns a text with a value and a rank. I want to create a chart showing the bars ordered by the rank, that I don't want to see on the chart, keeping the sheet ordered by Column A
In the attached I've used an Index/Match to lookup the data into another range and used that to chart it.
You can hide the range away for the sake of neatness if you like.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks