V vonda wooden New Member Oct 2, 2016 #1 1. Tracking actuals, original goals and projections every month and need to report, per state, per line time, per year, and full year. see attached. Attachments example.xlsx example.xlsx 10.4 KB · Views: 9
1. Tracking actuals, original goals and projections every month and need to report, per state, per line time, per year, and full year. see attached.
Chihiro Excel Ninja Oct 3, 2016 #2 Many dashboard set up does not require any coding. Just creative use of formula, named range and other native Excel tools. One such example is Chandeep's dashboard found in below page. http://chandoo.org/wp/2016/08/30/visualizing-financial-metrics/ I'd recommend you follow tutorials found on this site and adopt it to your specific need. http://chandoo.org/wp/excel-dashboards/ http://chandoo.org/wp/excel-dashboards/examples/
Many dashboard set up does not require any coding. Just creative use of formula, named range and other native Excel tools. One such example is Chandeep's dashboard found in below page. http://chandoo.org/wp/2016/08/30/visualizing-financial-metrics/ I'd recommend you follow tutorials found on this site and adopt it to your specific need. http://chandoo.org/wp/excel-dashboards/ http://chandoo.org/wp/excel-dashboards/examples/