In my pivot table I have a lot of articles and months. I have aggregated values for average weight and average price pr month. I want to do some comparisons in a linechart.

So I make the chart, and have months on x axis. The articles price and the articles weight on the y axis. So I will get 2 lines pr article. I will compare different articles every time.

Do I have to mark the dataseries for each article, or could I just say that weight is a secondary axis parameter? How do I do this?

this really annoyes me, because the way I do it now is way to time consuming.