Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The codes are <S2>,<S3> or <S4> for dotted lines.
flipside
Great – thanks very much for the quick reply.