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.