As far as I know, you would need to create this as two different charts.
Chart 1: Contains Series 1 as column and Series 3 as line overlay
Chart 2: Contains Series 2 as column and Series 4 as line overlay
Then in Chart 2, make everything apart from the columns and line invisible and position it in front of the Chart 1 content with a slight offset so the columns appear beside the Chart 1 columns.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|