create line chart with two axises in Pivot Chart

[Guest]

Hi,

I want to show two data series: Sum of Turnovers and Sum of Turnover Assets
in the pivot table simultaneously in the pivot chart. When I use a line
chart, the data points from two series are just connected into one line. Even
if I select Chart Type to be Line with Two Axises, it doesn't help.

I could, as a compromise, use column charts which does show the data points
separately, but they are all in the same color. I could also change
individual colmn's color, but that's too laborious...

Any help is appreciated.

 

[Guest]

If you are seeing a single series, then the datapoints are adjacent in the
spreadsheet. You need to have the Sum of Turnovers and the Sum of Turnover
Assets laid out differently in the pivot table.

Drag the Data button of the pivot table to the Column area of the pivot table.