Hi there,

Please would anyone be kind enough to help me with the following.

I'm trying to create a chart to that will only show the top 5 records from a range in a chart. For example, I would like a chart that from the following list, only shows the Johnson, Smith, Foster, Webster and Maguire as the top 5 salesmen without having to sort the data or use filters.

Is this possible?

Many thanks,

Dave

Name Cars Sold
Webster 15
Mcgiven 2
Hendry 1
Ince 3
Johnson 10
Smith 12
Foster 11
Maguire 9