Dynamic Chart - For Monthly, Quarterly & Annual Views. Number of periods shown can be changed instantly.

Description
For those who use interactive dashboards, this is an ideal piece of analysis that allows the user to:
1. Change the view to monthly, quarterly or annual.
2. Choose the number of periods that want to be shown on the graph.

By doing so, it means that users are able to hone in on the part of the data that is most important to them and tell the story that can sometimes be lost when looking at big graphs and data tables.

The model requires only four inputs which are:
1. Start date of the data table (Cell C8). Start date of the first period you have data for.
2. Period type you wish the model to show (Cell B4). This is a drop down menu and allows a choice of monthly, quarterly or annual.
3. Start date of the graph (Cell C16). This is the first date point for the graph. Please make sure that the date from the drop down menu equals one of those in the data table if the monthly, quarterly or annual view has been changed
4. Periods to view (Slider in D17). This is the clever bit which changes the graph to have different periods on the graph, depending on what the user click on from the slider.

The graph is simple but nifty to use and helps those users who like to play around with the information they have been given.