I want to create a chart to analyse multiple date selections:
the X-axis should plot the time
the Y-axis should plot the volume

in the chart itself I want to see the forecasted volume per product, but
split out in actual sales and prospected sales.
thus per product (A, B, C, etc) I would like to see a bar per month,
representing the total forecasted volume.

this bar should be divided into 2 data fields (actual sales and prospected
sales)

does anyone know how to do this? Or is it even possible? I have been trying,
but cannot get it right. it feels like the data I have in the excel sheet
should be sorted or represented differently, but don't know how.

thanks in advance!