I'd like to create a dynamic chart which shows all orders by months. The user enters the start year and the end year. He or she can also select the orders by shop or all shops (value 0). I use the following formula for counting the orders in C5:
The chart in my example workbook is static as I don't know how to make them dynamic. I need to use VBA to set the start year/end year and and fill the remaining rows with the correct year/month and the formula. I don't know how to do that. Everything is controlled with userforms and the chart will be copied in a userform. Can this also be done with a Pivot Chart? I'm not good with such charts though ..
Could you please have a quick look at my workbook and give me a clue how this can be done?