Using secondary axis

Thanks for help. I summarize what I learned:

So there is no ready option in the chart type selection for combination charts, or combination charts with 2 axes. For a 2 axes chart, you have to first create a simple chart type, say a column chart and then edit it.

Now, to modify my chart, I point and left-click the data series that I want to put on the secondary axis, then I right-click it to open the menu. Then I click "Format Data Series", select "Axis" and finally "Plot series on secondary axis".

Further, if I want to display one of the data series with line chart instead of a column chart, I first left-click that data series to activate it. Then I can click on the line chart type in the chart types selection, and voila - the data series I selected turns into a curve.

Thanks for help. I summarize what I learned:

So there is no ready option in the chart type selection for combination charts, or combination charts with 2 axes. For a 2 axes chart, you have to first create a simple chart type, say a column chart and then edit it.

Now, to modify my chart, I point and left-click the data series that I want to put on the secondary axis, then I right-click it to open the menu. Then I click "Format Data Series", select "Axis" and finally "Plot series on secondary axis".

Further, if I want to display one of the data series with line chart instead of a column chart, I first left-click that data series to activate it. Then I can click on the line chart type in the chart types selection, and voila - the data series I selected turns into a curve, while the other one remains in a column format.