Ranking Chart

[cartera]

Hello

I have to do a chart from a lot of different dealers. However, I only
want the top 10 dealers to be on the chart and a sum of the rest as
others. Is that possible?

How could I do a tornado style chart?


Thanks for your help

 

[Andy Pope]

Hi,

You will need to sort your data before it goes into the chart.
You can then either manually select the top 10 or use Dynamic ranges to
specify the top 10 items.
Both Jon and Tushar, see tornado links, have pages on dynamic named
range charting.

Collection of tornado charts
http://peltiertech.com/Excel/Charts/tornadochart.html
http://tushar-mehta.com/excel/software/tornado/index.html
http://www.andypope.info/ngs/ng3.htm

Cheers
Andy

 

[cartera]

Hi

thanks for your reply, where can i find further information on dynamic
ranges? sorry, im a new user.

 

[Andy Pope]

http://peltiertech.com/Excel/Charts/Dynamics.html
http://tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html