Style for charting

amandus99 · Post by **amandus99** » Tue Nov 03, 2009 2:46 am

Hi,
sorry but this isn't the solution. I need an expression for the label of series 2. The values for series 2 are calculated by series2 - series1, but the label should be only series 2. In your example I painted the desired values for the labels of series 2

Post by **Edward** » Tue Nov 03, 2009 4:38 am

Hi

At the moment this is not possible, but the workaround you can find in the attached file, sorry yesterday I attached wrong file.

Thank you.

amandus99 · Post by **amandus99** » Thu Nov 05, 2009 4:14 am

Hi Edward,
I need the argument for other values. I can't use it for labeling. So in the first step I removed the labels for the second series, not nice, but I think I have no other option...
But another thing is the placement of the labels. I tried to use the format property to format the key into currency, it is formatted as #,##€ if I choose C as paramter, but i need # €. What is the difference between the parameters C and C2?
I tried to solve this by not using the format property. I used the text after property with the string " €". But now the Label is too close or even over the border of its series as you can see in the attachment.

Post by **Edward** » Thu Nov 05, 2009 4:06 pm

amandus99 wrote:I tried to use the format property to format the key into currency, it is formatted as #,##€ if I choose C as paramter, but i need # €. What is the difference between the parameters C and C2?

The difference between C and C2 is amount of decimal places after the value which is being treated as Currency. The default format you probably had for currency values was with two decimal places that is why C and C2 produced the same result.

So C - is a default system formatting for currency values.
C2 - is a default system formatting for currency values but with fixed 2 decimal places.

So you could type in the formatting combobox your own value:
C1 or C4 or C0

I tried to solve this by not using the format property. I used the text after property with the string " €". But now the Label is too close or even over the border of its series as you can see in the attachment.

Yes, this solution consumed some extra space and result was not good.

Just set the following formatting value in the format combobox:

# €

I believe you receive the exactly result as you needed

Thank you.

amandus99 · Post by **amandus99** » Fri Nov 06, 2009 2:05 am

Hi Edward,

Thanks for the explanation with the C parameter.
Now I tried with C0 and also with # €, but the result is always the same behavior as mentioned in my post before, the label are placed over the border when the value is greater than 1000.

Post by **Edward** » Mon Nov 09, 2009 1:57 pm

Hi

You are very welcome.

We will let you know what can be done about that intersection of SeriesLabels and chart edges.

Thank you.

Post by **Andrew** » Tue Nov 17, 2009 6:48 am

Hello,

The problem is fixed, now the PreventIntersection property will work correctly.
Changes will be available in the next prerelease build on 23-Nov-2009.

Thank you.