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...o&userid=37669
View this thread: http://www.excelforum.com/showthread...hreadid=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/softwa...ado/index.html
http://www.andypope.info/ngs/ng3.htm

Cheers
Andy

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

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...o&userid=37669
View this thread: http://www.excelforum.com/showthread...hreadid=572776

http://peltiertech.com/Excel/Charts/Dynamics.html
http://tushar-mehta.com/excel/newsgr...rts/index.html

cartera wrote:
Hi

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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info