Need advice with the creation of specific chart.

[sparur]

Hi, all.

Could you give me an advice for resolving my problem...

I want to create an One Line chart with 2 expressions:

1) Trend of % by specific Company (I do It).

2) Trend of rank same Company.

(for more details see an attachments)

Finally, I want a chart like Figure::

where

a blue line is a trend of percentage Company A by Quarter

and

a red line is a trend of Rank Company A by quarter.

Each of the lines attached to the axis Y. Blue to the left axis and red to the right.

Who has any idea how to implement it?

May be in one chart it's impossible?

I will be a glad to listen to any ideas.[:D] Thank for all.

[shumailh]

Use the below property and find the attachement,

Regards,
Shumail Hussain

[shumailh]

Attachement

[sparur]

Hi, thank for your answer.

But your expression for calculating Rank isn't correct.

I need trend of rank(company A) in comparison with other company by Quarter. That is the maximum rating must be equal to 3 (because the number of companies of all 3).

as shown in screenshot.

[sparur]

Does somebody has any ideas yet?

[shumailh]

I think you need to try to define rank in edit script mode.

Regards,
Shumail Hussain

[sparur]

Oh. no.

It's not flexible variant.

But if nothing else is found, it probably will.

Regards, Anatoly.