Guage Chart

[#1]

my excel design is that

Company	Money	ComDate
a	400	20121016
b	300	20121016
C	200	20121016
d	100	20121016
a	100	20121017
b	200	20121017
C	300	20121017
d	400	20121017

I want to use ONE chart to show the highest money and use another chart to  show the second-high money.

At the same time, I can show the "Company" as the title.

Thanks.

[#2]

Hi,

Do you need the highest Money per Date and per Company?

Regards,

Janzen

[#3]

Hi Grace,

Please Find this attachment.

Hope this helps You.

Max-1= FieldValue('salary',FieldIndex('salary',max(salary))-1)

Max=Max(salary)

Regards,

Kabilan K.

[#4]

Hi,

Hope this one helps,

Regards,

Janzen

[#5]

Thanks all of you.

But it still cannot show "Company" above the chart.

That's mean if Company A has the largest money on that day, I want the chart show the money and the company name.

Thanks again!

[#6]

Hi,

U can write a expression in Title text box like below.

='Company'&FieldValue('Company',FieldIndex('Money',max(Money)))&'__'&FieldValue('Money',FieldIndex('Money',max(Money)))

Regards,

Kabilan K.