|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-30-2005, 07:19 AM
|
|||
|
|||
|
Changing colours in chart
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 
|
|
#2
05-30-2005, 09:05 AM
|
|||
|
|||
|
Re: Changing colours in chart
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
