jeudi 6 août 2015

Is it possible to change the line style in an Excel chart according to a value in a cell?

I was wondering if it is possible to change the style of a line (e.g. its color, style, or any other property) according to the value of the cell. Something like this:

data#  |  value1  | value2 | condition
1      |    3     |   5    |
2      |    5     |   7    |  true

Line 1 should be normal, whereas line 2 must be dashed since the fourth column says true. Any idea? Or any workaround?

Aucun commentaire:

Enregistrer un commentaire