Connect 2 lines on a combo chart

[Anonymous]

Hi everyone, I have a graph where I have 2 different lines (and bars as well but let's focus on the lines). These lines calculate both the Forecast Bias. However, one is calculating the past (stopping on the previous month) while the other is culculating the current month.

The issue is that the line calculating the past stops on the previous month (as it should) while the one for the current looks just as a dot.

My question is, is there any possible way to connect the point of the previous month with the dot of the current month so the entire line shows as a continuous one? I would like to create just a connection in order to show also the different colors between the different data sets.

Thanks in advance!

[v-frfei-msft]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.