Chart Control - FP11_DLGCHART5 Video Question

[Melissa Smith]

I've implemented the technique describe in the two videos under FP11_DLGCHART5. The chart data that I'm using is a numeric value, but the hover message displays it without any formatting, so the numbers look like: 123456.12255

I'd like the format to be (at least) like: 123,456.12, but ideally I'd prefer the format like: $123,456.12 if possible.

I'm wondering if anyone knows how to format the number or style of the chart.value that is being called with the JS function; I'm a complete novice. I'm using the code provided from the component template that is provided with the videos.

This is the code for the JavaScript Function:

function positionChartBubbleHelp(ele,event) {
	var coords = $e.getCoors(event);
	var offsetY = -10;
	var offsetX = 10;
	ele.style.top = (coords.clientY + offsetY) + 'px';
	ele.style.left = (coords.clientX + offsetX) + 'px';
}

And this is the code from the Chart Events onMouseOver:

/*
Your Javascript code can reference these variables: 
chart.seriesNumber (0 based), 
chart.pointNumber (0 based point number in the series), 
chart.value (value for the point)	
chart.xvalue (value for the x-axis value (used in x-y and scatter charts)
legend.label (text label on the legend - if the chart has a legend)
point.label (text for point label)
*/
var msg = 'Amount: '+ chart.value;
var ele = $('floatingMessage');
ele.innerHTML = msg;
ele.style.display = '';
positionChartBubbleHelp(ele,event);

Regards,
Mel

[Melissa Smith]

Re: Chart Control - FP11_DLGCHART5 Video Question

UPDATE: I had some time to fiddle around with the Chart Events onMouseOver code and resolved the number display. It was (embarrassingly) as simple as changing the variable to: var msg = legend.label;

If your Data Label series is formatted, then it will copy over to the JavaScript event. My Data Label expression is: chart.category+": "+ut(str(chart.data,20,2,"$"))

My Chart Events onMouseOver code looks like this now:

/*
Your Javascript code can reference these variables: 
chart.seriesNumber (0 based), 
chart.pointNumber (0 based point number in the series), 
chart.value (value for the point)	
chart.xvalue (value for the x-axis value (used in x-y and scatter charts)
legend.label (text label on the legend - if the chart has a legend)
point.label (text for point label)
*/

var msg = legend.label;
var ele = $('floatingMessage');
ele.innerHTML = msg;
ele.style.display = '';
positionChartBubbleHelp(ele,event);

[Tasos]

Re: Chart Control - FP11_DLGCHART5 Video Question

Hi Melissa
any chance of documenting all the steps.
I have tried to reproduce the results but i receive an error message
Your help will be appreciated