|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 5th, 2005, 08:45 AM
|
|||
|
|||
Changing Series Color
The data in my series is sometime positive ( 0 ) and sometimes negative ( 0).
If there is a way to present the positive and negative data points in different coloros Thanks -- Eli Kedar Israel 
|
|
#2
July 5th, 2005, 09:14 AM
|
|||
|
|||
|
Hi,
I have an explanation of how to make use of the Invert If negative option. http://www.andypope.info/charts/Invertneg.htm You may also find Jon's article on conditional charts useful. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Eli Kedar wrote: The data in my series is sometime positive ( 0 ) and sometimes negative ( 0). If there is a way to present the positive and negative data points in different coloros Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#3
July 5th, 2005, 09:43 AM
|
|||
|
|||
|
Thank you for the promt answer
-- Eli Kedar Israel "Andy Pope" wrote: Hi, I have an explanation of how to make use of the Invert If negative option. http://www.andypope.info/charts/Invertneg.htm You may also find Jon's article on conditional charts useful. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Eli Kedar wrote: The data in my series is sometime positive ( 0 ) and sometimes negative ( 0). If there is a way to present the positive and negative data points in different coloros Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I stop the font color from changing in new emails? | Postmaniac | General Discussion | 4 | April 28th, 2005 05:30 PM |
| Changing end date of series restores deleted appointments | GE | Calendar | 1 | April 14th, 2005 06:16 PM |
| Quickly Changing Several Series to Appear the Same | Barb Reinhardt | Charts and Charting | 2 | February 7th, 2005 03:10 PM |
| How to stop spammers from changing display color in inbox (Outloo. | Doc | General Discussion | 1 | January 30th, 2005 04:57 PM |
| Changing line color within a chart | Dwayne Smith | Charts and Charting | 3 | February 15th, 2004 02:41 AM |
Linear Mode
