Hi,

The explanation may help. It's based on a column chart but the
principles are the same.
http://www.andypope.info/tips/tip005.htm

Cheers
Andy

GEMINI MAN wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info