| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display negative data points differently.
How do I change the color or format of a line and/or bar so that negative
numbers in a data series are displayed differently. Specifically, I would like to draw more attention to a series when it crosses the -0- line because this particular chart displays 4 separate series' already. |
|
#2
|
|||
|
|||
|
Jon Peltier has instructions for conditional charts:
http://www.peltiertech.com/Excel/Cha...nalChart1.html Andy Pope has instructions for inverting negative values: http://www.andypope.info/charts/Invertneg.htm And for conditional line charts: http://www.andypope.info/charts/conditionalline.htm MRN wrote: How do I change the color or format of a line and/or bar so that negative numbers in a data series are displayed differently. Specifically, I would like to draw more attention to a series when it crosses the -0- line because this particular chart displays 4 separate series' already. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
| Formulas in source data | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
