If you want it dotted in some places and a line in others, you'll need to
have a series for the dotted line and a series for the solid line.

Good luck.

"JeroenM" wrote:

Hello,

I have the following question:
I have an Excel chart with a target line. In some cases I want to have the
target line as a dotted line, and sometines as a continuous line. Somewhere
on the worksheet is a cell wich determines if it must be a dotted or
continous line. Is it possible to make the chart in such way that if I
change the cell for continuous/dotted, the line in the chart is updated
automatically (from dotted to continuous or the other way).

Thanks in advance,

JeroenM.