View Single Post
 
Old 08-11-2021, 09:04 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote