It sounds like the simplest way to do this is to forget for a moment
that you're working with charts. Just do your calculations, and put
the results in their own column or row. Once you've got your
calculations right, building the chart through the chart wizard is
pretty easy.
--
BruceP
------------------------------------------------------------------------
BruceP's Profile:
http://www.excelforum.com/member.php...o&userid=33653
View this thread:
http://www.excelforum.com/showthread...hreadid=539681