About Dashboard:
Dashboard is the source to present the analyses in one report. To prepare the dashboards we use the different types of chart to present the numbers and graphic picture for the better understanding.
In this dashboard we have 2 type of dashboards:- R & D , PDL dashboards.
In this article we can see the charts analyses:-
R & D report
Line and Column charts used to show the graphical picture to API research, where we can compare to budget and actual as per the last year.
Column chart used to show the quarter wise numbers to the last year.
Above shown chart is the combination of the Column and Line chart used to show the budget and actual amount department wise.
In this chart we can see the graphical status to FTM and YTD according to Budget and Actual amount.
In this chart we can see the graphical status to FTM and YTD according to last year and actual.
Bar chart used to show the Actual and budget amount department wise.
PDL report
Line and Column charts used to show the graphical picture to API research, where we can compare to budget and actual as per the last year.
Column chart used to show the quarter wise numbers to the last year.
Above shown chart is the combination of the Column and Line chart used to show the budget and actual amount department wise.
In this chart we can see the graphical status to FTM and YTD according to Budget and Actual amount.
In this chart we can see the graphical status to FTM and YTD according to last year and actual.
Bar chart used to show the Actual and budget amount department wise.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
A debt of gratitude is in order of sharing amazing gizmo regarding excel, it's was helpful and suggestive too.
great post, one should must say that , awesome work done by blogger .Thanks for sharing!