pivot chart how to add second vertical axis

[yabi100]

In ordinary excel chart it is possible to assign second vertical axis. By second vertical axis I mean left and right vertical axis shows different columns of the table and have different scales. Is it possible to do it in pivot chart?

 

[jdellasala]

Select the chart, and under Chart Design tab, select Change Chart Type and select Combo at the bottom and check the Secondary Axis box for the data secondary data:

You can make adjustments by using the drop down selection under the Format tab:

That should do it!