any way to arrange the categories on a bar chart by ascending/descending order

[tukae]

I want to list the categories on my bar chart by ascending/descending order of their values rather than alphabetical order or column order. Is this possible?

For example:

	A	B
1	aaa	5
2	bbb	3
3	ccc	7
4	ddd	1
5	eee	2

Which gives:

chart1.png

But I want:

chart2.png

[BadlySpelledBuoy]

Have a look at the attached for one way of doing this.
The yellow cells rank the values in column B. The green cells use this ranking to look up the data in order.
The chart is then based on the green cells.

As your data changes the order will change to match.

You could also accomplish this with pivot tables and pivot charts.

BSB

[tukae]

That's a nice way of doing it. Thanks, BadlySpelledBuoy.

I'll also look into pivot tables and pivot charts.