| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| How to change the color of the series markers from yellow to Black | Charts and Charting in Excel | |||
| Changing the color of a Series Collection using visual basic? | Charts and Charting in Excel | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Changing color in color palette | Setting up and Configuration of Excel | |||
Linear Mode
