Hi, I added a linear trendline to my expression, but the part that is forecasted is a solid line, when I want it to be dotted. Any suggestions?
I know of no way to format trendlines other than line width (on presentation tab). There may be a method of calculating it using another expression and formatting that.
See the image to change the line style.
Yes, but that is a main data expression. What about a trendline?
You are correct. I don't know how to change, but using your idea to create another expression maybe solve the problem changing line style.
Under the expression, in the Line Style section you could use an IF statment like:
<s1> is a solid line
<s2> is a dotted line
I hope this helps.
Can you please provide a test application ,i will give a answer for that one,
other wise in line style you can add '<S2>' or '<S3>' you will get doted line.
I'm sure you've found an alternate solution by now, but I wanted to post this here in case it helps anyone in the future: http://www.infinityinsight.com/blog/?p=295
Retrieving data ...