Hi All,

I would like to create bar graph using vba. I know how to do a simple bar
graph, but need help with a bit more complex one (well complex for me).

I have the following data in my excel sheet:

A B
1 Fish 0
2 Dog 2
3 Cat 4
4 Rat 0
5 Bat 5


I would like to have a bar graph with the first bar to be Bat (5), Cat(4),
Dog (2), Fish(0), and Rat (0)............ But the bar graph will change if
the value of B changes. So the bar graph should look for the largest value
and have that to be the first bar and then the second largest value to be the
second bar and so on.

Please help. Thanks

Tracktraining
--
Learning