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/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

[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/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