2 datasets on horizontal axis

[Gaellus]

I have multiple productgroups with a forecast. The blue cells.
In the grey cells I have the sales numbers for those productgroups.
each column is a different month but column B (forecast) is the same month as column Q (Sales). C with R etc.

I would like to have the forecast and sales per month below eachother in the line graph (or any other chart). Not besides eachother.
Is that possible?

[AskMeAboutExcel]

yes, you can do this by adding more series to the chart.

At the moment you have 4 series A-B-C-D, with each have data from columns B:AE

Instead you want 8 series:

A - Forecast - cells B2:P2
A - Sales - cells Q2:AE2
B - Forecast - cells B3:P3
B - Sales - cells Q3:AE3
etc...

[Gaellus]

damn lol it is that easy.
Thanks!

[AskMeAboutExcel]

Easy, once you know how