Pivot flow chart (line) showing week, month by choice, different products

Can you please explain the layout of the sheet? What do the column headers represent, and how do I tell what the products are? The data are not set up for good pivot table use so we will have to figure out a way around that.

I added some helper columns. This program makes used of a pivot table to collect and organize the data. However, it is overlaid with named dynamic ranges for the purposes of plotting the charts. I also had to add in some headers since pivot tables don't like blank column headers.

I recorded a macro to give me the syntax I needed to "swap out" the first column in the pivot chart which, by design, are named Daily, Weekly and Monthly - the same as the dropdown list in cell B4 on the chart page. If you translate this program make sure the code matches the dropdown names. I highlighted these column headers in orange on the marktprijzen sheet. Make sure you pick them up in the pivot table as well.

I "translated" the product names to Product 1, Product 2, etc. You can change these in the pivot table headers and on the names of the series on the chart without affecting the code. You can also change them in cells A10:A13 on the chart sheet without issue.

I have 4 calculated fields in the pivot chart to compute the row percent. I switch what to plot by adding an extra offset to the named dynamic ranges. Cell E1 on the pivot sheet manages this. Once again, if you change the dropdown values in cell B6 on the Chart page, change the formula in Cell E1.

Finally, I hide series you don't want to see on the chart by hiding the columns on data driving the chart. It's an old trick, but it still works.

I also threw in a pair of start and end dates. These calculate into the Use helper column. This column also makes sure that the non-date values in the data don't mess up the pivot chart.