Hi
one way would be to put his actual payout as a 2nd series. assuming its
an xy chart:

put your % values on the x axis,
the hypothetical values in series one, and
the actual payout against achieved percentage as series two.

Set

series one style to plain line (no marker),
series two to marker only (no line)

and you'll get the effect I think you want


--
Nicky


------------------------------------------------------------------------
Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
View this thread: http://www.excelforum.com/showthread...hreadid=522348