ItalFreak

How to place DataLabels correct on X-axis ?

Recommended Posts

Hi,

 

 

 

I'm not sure how to explain this best so maybe a picture will help:

 

 

 

DatalLabelsFusionCharts.gif

 

 

 

On the X-axis I have RPM's but there is no relation between the value I have specified and the location on the X-axis.

 

The difference between the second and first value = 7778 - 6300 = 1478 RPM.

 

The difference between the 3rd and the 2nd = 8271 - 7778 = 493 RPM

 

The space between both is equal though.

 

 

 

I would like to scale or be able to move the labels and values along the X-axis in relation to its value. So in this case the gap between the 1st and 2nd value should be much bigger then between the 3rd and the 2nd.

 

 

 

Is there any way I can do this ?

 

(Not divide the X-axis equally but in relation to the minimum-maximum values I specify)

 

 

 

Hope this is somewhat clear....

 

 

 

Best regards, Jean

Share this post


Link to post
Share on other sites

Hi Drhuva,

 

 

 

I don't see how a scatter chart could help as it also divides the x-axis in even spaces.

 

What I would like to to is place the data labels according to their value on the x-axis.

 

 

 

Say I have an X-axis that starts at 6000 and ends at 10000.

 

My X-axis data label values are 6500, 7000, 9000, 9100 and 9200.

 

5 Data labels now are divided evenly over the X-axis where the distance between label '7000' and label '9000' is equal to the distance between 9000 and 9100.

 

 

 

Now I would like to be able to place the data labels relative to the Y-axis in percent of the total X-axis. In this case:

 

Label 6000 would be at 0%

 

Label 6500 would be at (6500 - 6000) / (10000 - 6000) *100 = 12.5% from the left.

 

Label 7000 would be at (7000 - 6000) / (10000 - 6000) *100 = 25.0% from the left.

 

Label 9000 would be at (9000 - 6000) / (10000 - 6000) *100 = 75.0% from the left.

 

Label 9100 would be at (9100 - 6000) / (10000 - 6000) *100 = 77.5.0% from the left.

 

Label 9200 would be at (9100 - 6000) / (10000 - 6000) *100 = 80.0.0% from the left.

 

Label 10000 would be 100%

 

 

Edited by Guest

Share this post


Link to post
Share on other sites

Hello,

A scatter chart can be scaled manually by specifying x-axes coordinates. Please check with a sample XML I am pasting here.

<chart palette='2' caption='Server Performance' numDivLines='13' yAxisName='Response Time (sec)' xAxisName='Server Load (TPS)' rotateNames='0' showLegend='1' showNames='1' xAxisMaxValue='100' xAxisMinValue='10' yAxisMaxValue='7' decimals='1'>

<categories verticalLineColor='666666' verticalLineThickness='1'>

<category label='10' x='10' showVerticalLine='1'/>

<category label='20' x='20' showVerticalLine='1'/>

<category label='30' x='30' showVerticalLine='1'/>

<category label='70' x='70' showVerticalLine='1'/>

<category label='80' x='80' showVerticalLine='1'/>

<category label='90' x='90' showVerticalLine='1'/>

<category label='100' x='100' showVerticalLine='0'/>

</categories>

<dataSet seriesName='Server 1' color='009900'

anchorSides='3' anchorRadius='4' anchorBgColor='D5FFD5' anchorBorderColor='009900' >

<set y='2.4' x='21' />

<set y='3.5' x='32' />

<set y='2.5' x='43' />

<set y='4.1' x='48' />

<set y='3.5' x='50' />

<set y='4.6' x='56' />

<set y='4.8' x='59' />

<set y='4.9' x='73' />

<set y='4.6' x='89' />

<set y='4.2' x='93' />

</dataSet>

<dataSet seriesName='Server 2' color='0000FF'

anchorSides='4' anchorRadius='4' anchorBgColor='C6C6FF' anchorBorderColor='0000FF'>

<set y='1.4' x='23'/>

<set y='1.5' x='29'/>

<set y='1.5' x='33'/>

<set y='1.1' x='41'/>

<set y='1.5' x='47'/>

<set y='1.6' x='49'/>

<set y='1.8' x='51'/>

<set y='1.9' x='53'/>

<set y='1.6' x='57'/>

<set y='1.2' x='58'/>

<set y='1.9' x='61'/>

<set y='1.1' x='63'/>

<set y='1.9' x='64'/>

<set y='1.7' x='71'/>

<set y='1.1' x='77'/>

<set y='1.3' x='79'/>

<set y='1.7' x='83'/>

<set y='1.8' x='89'/>

<set y='1.9' x='91'/>

<set y='1.0' x='93'/>

</dataSet>

<vTrendlines>

<line startValue='20' endValue='65' alpha='5' color='00FF00' />

<line startValue='65' endValue='75' alpha='15' color='FFFF00' />

<line startValue='75' endValue='100' alpha='15' color='FF0000' />

</vTrendlines>

<hTrendlines>

<line startValue='5.2' displayValue='Check' lineThickness='2' color='FF0000' valueOnRight='1' dashed='1' dashGap='5'/>

</hTrendlines>

</chart>

 

I think the scatter chart will be able to produce the kind of chart you require. I hope this helps!

Share this post


Link to post
Share on other sites

Hi Druhva,

 

 

 

Yes now I see. This is exactly what I need....in a Line chart ;-)

 

 

 

I could use the scatter chart if it could connect the 'scatter dots' but I don't think that is possible.

 

It would be great to have this functionality in all the Line charts.

 

Is there a point in submitting this as a future request ?

 

 

 

Regards, Jean

Share this post


Link to post
Share on other sites

In the <dataset> element, could you add drawLine=1 and try again? Muahaha :cool:

Also, if you do have feature request you'd like to make, please do! We do take all feature request into account when we design our products. :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now