how to make show value of trend line?

[barado43]

HI.

I have made specific chart with trendline which is average value but there is no option that showing value of trendline.

there is only string input showing label.

of cause I can put 'value + label' to  displayValue.

but I want value and label are separated to other Y axis.

Is it possible to showing that?

If not is it possible force to make carriage return between value and label?

value and label is too long if put together and I have no idea how to make carriage return between them.

Thanks in advance.

[Dhruva]

Hello barado43,

In addition to putting value and label as displayValue, please try using the valueOnRight attribute for the <line> element in the XML. The general format would be as follows:

<line startValue='10' color='FF0000' displayValue='Average' valueOnRight = '1'/>

Please let us know if this solves your problem, or feel free to get back to us for further assistance.

[barado43]

Thanks.

Yes I did exactly same as your XML string before. but seems valueOnRight parameter does not work properly.

if I set valueOnRight = 0 , string of displayValue 'average' is located left that's all right.

valueOnRight = 1, 'average' is located right, but value is not display.

guess valueOnRight effected only location of displayValue label not average value ifself display.

seems this could be BUG reporting.

could you try yourself again?

 

Regards.

[Dhruva]

The valueOnRight attribute shifts the display value string to the right, it does not display the numerical value of the trendline itself. To display the numerical value of the trendline, you will have to manually put the value in the displayValue attribute (Which, I presume, you were doing initially).

However, there is a way to force a carriage return within the string. To do that, one must use <styles>. Styles has to be added into the XML within the <chart></chart> tags. The general format for using styles in this case should be something like this:

<styles>

  <definition>

  <style name='MyFirstFontStyle' type='font' isHTML='1' />

  </definition>

  <application>

  <apply toObject='TRENDVALUES' styles='MyFirstFontStyle' />

  </application>

</styles>

And then, the displayValue string should be modified thus:

<line startValue='30000' color='009933' displayValue='Target <br> 30000' />

(Here, Target is the label, and the numerical value is 30000.)

This should solve the problem. Especially if you also move this to the right (using valueOnRight) it should result in a much better viewing clarity.

I hope this will help. We look forward to hearing from you.

Edited March 27, 2009 by Guest

[barado43]

Thanks a lot.

Finally I finished my job.

and It would be more great if value and string are separate and independently controlled though

I hope next version or upgrade would include this.

Thanks again.

Best regards.

[Dhruva]

You're most welcome! We will certainly keep your suggestion in mind for the next release!