Dynamic chart automatically changing its range if we select wrong date

[maniknandi]

I have prepared a dynamic chart, we can select month, year and sales person. The chart is automatically generated monthly sales done by the sales persons . The starting date is 7-Apr-12 and end date is 31-Mar-13.

The problem is that if we put the month and date not in our date range, the chart lost its data range.

Please help me and thanks in advance.

[Steve=True]

Hi Maniknandi,

I would recommend only showing the user the valid choices. I have modified your dynamic spreadsheet to give you what you need by adding a new table on the CAL tab that is controlled by a new form control on the Report tab.

Sales Analysis Database Month Picker Fix.xlsx


Let me know what you think.

Steve=True

[maniknandi]

Hi Steve,

Thank your for your assistance. The new table that you have generated is not dynamic. If I use data validation instead of form control the new table is not needed for that. What do you think?

Thanks,

Manik