Hmm, not sure you need a macro. Hv a look at Andy Pope's excellent pages for
instance:
http://www.andypope.info/charts/Invertneg.htm

GL,
Henk

"Richard Flame" wrote:


http://exceltips.vitalnews.com/Pages...n_a_Chart.html

This might give u an idea


--
Richard Flame
------------------------------------------------------------------------
Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
View this thread: http://www.excelforum.com/showthread...hreadid=557866