chart values

[noman212]

Hello

i have a bar chart 5 bar showing on chart each has a different value from other i want to pick and show only 2nd value of bar chart in a pie chart how can i do this pls help .

Thanks in advance

Regards

[crusader_]

Hi,

You can use rank() - function to define 2nd value.

HTH

Andrei