| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line Series Color on Graph
Is there a way to make a line series on a line graph change colors based on
the value of another line? I have a line graph that has 2 lines. 1 green line representing Total Expenses and 1 line representing Total Revenue. I would like the line representing Total Revenue to be red whenever it is below the line representing Total Expenses and then change to blue whenever it goes above the Total Expenses line. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Series Color on Graph
Check out Jon's page on conditional chart formatting:
http://peltiertech.com/Excel/Charts/...html#CondChart -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nate" wrote: Is there a way to make a line series on a line graph change colors based on the value of another line? I have a line graph that has 2 lines. 1 green line representing Total Expenses and 1 line representing Total Revenue. I would like the line representing Total Revenue to be red whenever it is below the line representing Total Expenses and then change to blue whenever it goes above the Total Expenses line. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line Series Color on Graph
Excel 2007
Conditional line segment colors. Step chart. With macro. http://www.mediafire.com/file/ztz1itzogoj/01_13_10.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unwanted Series Values on Line Graph | Excel Discussion (Misc queries) | |||
| How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
| Line Graph: Differences between series | Charts and Charting in Excel | |||
| Add series to line graph | Charts and Charting in Excel | |||
| How do I add one line series to a bar graph? | Charts and Charting in Excel | |||
Linear Mode
