Hi.I have to edit this excelchart, but i have no idea how to do, cause i
am new in excel
The read arey have to be blue and otherwise.
http://web3.p15137269.pureserver.inf...excel/orig.JPG

rightclick on the dataserias and then "Format Data series" bringing up
this dialog:
http://web3.p15137269.pureserver.inf...excel/prob.JPG

Then i change from red to blue.
http://web3.p15137269.pureserver.inf...xcel/prob2.JPG

And it looks so:
http://web3.p15137269.pureserver.inf.../excel/new.JPG

If i uncheck "invert if negative" the whole chart is only in one
colour.
i thought, if i change colour from red to blue with "invert if
negative" checked, the result should be right. :(

changing the colour of every single part is not good, i think, because
i want that negative values are red automaticly if i enter new values.

ciao Witzman


--
witzman
------------------------------------------------------------------------
witzman's Profile: http://www.excelforum.com/member.php...o&userid=23854
View this thread: http://www.excelforum.com/showthread...hreadid=375008

Hi,

Here is an explanation of Invert if negative
http://www.andypope.info/charts/Invertneg.htm

Cheers
Andy

witzman wrote:
Hi.I have to edit this excelchart, but i have no idea how to do, cause i
am new in excel
The read arey have to be blue and otherwise.
http://web3.p15137269.pureserver.inf...excel/orig.JPG

rightclick on the dataserias and then "Format Data series" bringing up
this dialog:
http://web3.p15137269.pureserver.inf...excel/prob.JPG

Then i change from red to blue.
http://web3.p15137269.pureserver.inf...xcel/prob2.JPG

And it looks so:
http://web3.p15137269.pureserver.inf.../excel/new.JPG

If i uncheck "invert if negative" the whole chart is only in one
colour.
i thought, if i change colour from red to blue with "invert if
negative" checked, the result should be right. :(

changing the colour of every single part is not good, i think, because
i want that negative values are red automaticly if i enter new values.

ciao Witzman



--

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

Fine, thank you.

this link was exact what i was looking for.

ciao
Witzman


--
witzman
------------------------------------------------------------------------
witzman's Profile: http://www.excelforum.com/member.php...o&userid=23854
View this thread: http://www.excelforum.com/showthread...hreadid=375008