Hi Glen,

Here are two ways of do these.
If it is a once off task then you can select the individual data points
and apply data labels to just those points.
Select the data series and the click the Maximum data point.
Right click to format that specific point. Apply data labels.

To do it in a more dynamic way would require the use of some formulas.
The formula would display the value of only the min and max data.
The data labels could then be linked to the cells.

Asumming your data is in B2:B8 then enter a formula something like this
into C2:C8;
=IF(B2=MAX(B$2:B$8),"Max " & B2,IF(B2=MIN(B$2:B$8),"Min "& B2,""))

Using one of these two free addins will help with the linking.

Rob Bovey's XY Chart Labeler:
http://www.appspro.com/utilities/utilities.asp

JWalk Chart Tools:
http://j-walk.com/ss/excel/files/charttools.htm

glen wrote:
when showing data labels within a chart i only want to
show a maxmium & a minimum not all the values \. can this
be done
thanks

--

Cheers
Andy

http://www.andypope.info