Format Displayvalue Or Show Value Of Y-Axis Intersection

[zales33]

Hello,

I am using a MSSpline chart to represent a total variance (the dark line in the image) and various connected plots to represent the individual items whose variances comprise the total variance.

 

On the y-axis, I would like to only display the value where the dark variance line intersects the y-axis. This intersection point will vary from user to user so I cannot hard code a "K" or "M" to represent thousands or millions. Is it possible to have the point of intersection on the y-axis displayed? If it is possible, can it be formatted using the standard formatting of "K" or "M"? The surrounding charts use the standard formatting so I would like to be consistent..

 

I wasn't able to figure out how to have the intersection point displayed so I tried using a trend line whose startValue equals the total variance. I then used displayValue to display the actual value of the variance (rather than displaying an alpha description). This description appears like it's on the y-axis which is great. I would like to have the displayed value formatted using the standard formatting of "K" or "M" as I mention above. Is this possible?

 

I also tried to have the graph start at the value of the total variance (the dark line) instead of starting at 0. I was thinking that maybe if I chose to showZeroPlaneValue it would show my total variance amount becuase my chart now starts at the variance value rather than starting at 0. I couldn't figure this out either. Is this a possible solution?

 

I am totally open to changing what I am doing if there is a better way to accomplish my goal.

 

I appreciate any help you may be able to provide.

 

Thank you.

[Guest Sashibhusan]

Hi,

 

With regard to your query, to display only the variance value on Y-Axis with variance line, you need to provide the variance value as TrendLines and set "showYAxisValues" attribute of <chart> element to "0" in your XML code for MSSpline chart.

 

If you want to display the trend value in default number scaling format (i.e. 'K' or 'M'), either you can provide NULL value to "displayValue" attribute or can remove the "displayValue" attribute from the <trendlines> element of your XML file.

 

In either of the case, the chart will show the value provided to "startValue" attribute, with a default number scaling format.

 

Hope this helps!

[zales33]

Thank you very much for your assistance! I will modify my chart per your recommendation below. Thanks again!

 

Hi,

 

With regard to your query, to display only the variance value on Y-Axis with variance line, you need to provide the variance value as TrendLines and set "showYAxisValues" attribute of <chart> element to "0" in your XML code for MSSpline chart.

 

If you want to display the trend value in default number scaling format (i.e. 'K' or 'M'), either you can provide NULL value to "displayValue" attribute or can remove the "displayValue" attribute from the <trendlines> element of your XML file.

 

In either of the case, the chart will show the value provided to "startValue" attribute, with a default number scaling format.

 

Hope this helps!

 

 

 

 

 

[Guest Sashibhusan]

Hi,

 

You are welcome.

 

Please do let us know if we could be of any further help.