Another approach you could use, which I think would also solve your
new question, is to create your chart as normal, but then apply an
AutoFilter to your data and use the filter option Top Ten.
If you want the data sorted, you could do that too.
hth
ScottO

"hopeace"
wrote in message
...
|
| Creating the formula for the top ten worked great! New issue:
|
| How do I chose the aligned category or title of each of the chosen
top
| ten, so that I can include it in the chart I will make?
|
| =LARGE($A$23:$A$57,1) through to =LARGE($A$23:$A$57,10) is what i
| used.
|
| The titles are in C23:C57
|
| Thanks!!!
|
| keith
|
|
| --
| hopeace
| -------------------------------------------------------------------
-----
| hopeace's Profile:
http://www.excelforum.com/member.php...o&userid=28009
| View this thread:
http://www.excelforum.com/showthread...hreadid=475930
|