Line chart with two lines and hidden data labels

Hi all,

I want to create a line chart where the line shows the numbers for January to December 2018. The numbers for Jan-Mar needs to be realised numbers and Apr-Dec needs to be forecastet numbers. The end result being the viewer only looks at one line where Jan-Mar for example is green = actuals and Apr-Dec = blue is estimate/forecast.

What kind of chart can handle that?

My data is below

Realiseret Forecast
jan 6.227.215 0
feb 4.974.425 0
mar 0 4.293.069
apr 0 5.160.195
may 0 3.883.846
jun 0 3.945.446
jul 0 5.352.986
aug 0 5.558.124
sep 0 6.402.928
oct 0 5.210.457
nov 0 5.980.909
dec 0 4.826.467

Thank you in advance for any help I receive.

Excel will omit NA values from a chart series - so replace your zero values with NA(), then plot both series on the same chart, and format to suit.
I would add a couple of helper columns, for your chart data:

Formula:

Please Login or Register  to view this content.

There will be a gap in the line between the Actual / Forecast series, of course.

See attached workbook for a worked example.