| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional line color
Hi,
I'm trying to make a line graph for 203 subjects with 3 data points. I would like to color code the individual line based on another variable. I want 203 lines, but only 4 colors. Is there some way to do this without manually changing each individual line? Thanks for your help! Jessica |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
conditional line color
Have a look at
http://peltiertech.com/Excel/Charts/...nalChart1.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "JFolsom" wrote in message ... Hi, I'm trying to make a line graph for 203 subjects with 3 data points. I would like to color code the individual line based on another variable. I want 203 lines, but only 4 colors. Is there some way to do this without manually changing each individual line? Thanks for your help! Jessica |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format color is set correct, yet color will not change | Excel Worksheet Functions | |||
| How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| Changing a line color when it crosses another benchmark line? | Charts and Charting in Excel | |||
| Conditional color fill whole line... | Excel Worksheet Functions | |||
Linear Mode
