Line chart with dual Y axis, with different scale

[hose]

Hello!

I have an issue, that I can't solve. I want to recreate an Excel chart in Cognos Report Studio (10.1).
It is a simple line chart for 6 product and its growth data. And I have a country parameter with a drop down list. It's not a big deal. But in some county, one growth line is bigger, than the other. That's why the automatic scale goes up so high, that the other growth can't be seen on the chart.
How can I make that in this cases, the product with big growth can be seen on a second Y axis with a larger scale?

I've attached a picture, that shows what I want to make, and how I'm standing right now.

Thank you in advance!

[Todd129]

If the first data item you have been using for your y-axis measurement contains all countries:

Create a second data item that is only filtered for the value for your country that has the high value percentage.

Create a third data item that contains the value for only all the other countries.

Create your chart.  drag the third data item (above) to one axis and drag the second data item (above) to the second axis

Hope this helps!

Todd

[hose]

Thanks Todd. It helped.