ASP.NET, SQL Server, WPF, C#, VB.NET

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 
 
-- 
 
cartera 
 
------------------------------------------------------------------------ 
 
cartera's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37669 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=572776

Hi 
 
thanks for your reply, where can i find further information on dynamic 
 
ranges? sorry, im a new user. 
 
-- 
 
cartera 
 
------------------------------------------------------------------------ 
 
cartera's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37669 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=572776

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 wrote: 
 
-- 
 
Andy Pope, Microsoft MVP - Excel 
 
http://www.andypope.info

http://peltiertech.com/Excel/Charts/Dynamics.html 
 
http://tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html 
 
cartera wrote: 
 
-- 
 
Andy Pope, Microsoft MVP - Excel 
 
http://www.andypope.info