2 Replies Latest reply: Oct 11, 2012 3:43 AM by carolyn.miller RSS

    How to create a conditional dashed line?

      Hi

       

      I've got a time series line chart with actual rates mergeing into budgeted rates on teh same line. I want the line to change to a dashed line when it becomes budgetted data. I can't find what the code is for the different line style. For example you'd use B if you wanted bold text - what do you add to the formula to say a dashed line? Hope this makes sense.

       

      I can't change to a different coloured line as the dimension is cuclic and can contain many different lines.

       

      Thanks

      Caz