yes, calculate the compliance level putting the figure in, say, cell A1

Do your chart as normal

Highlight your chart and in the formula bar type =

then go to cell A1 and press return, and locate, format as desired

You now have a permanent link even when you amend your data


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=554866