Hi,
I have attached the data, with the help of macro I have to bring out the charts for the below criteria’s in a dashboard.
Week wise releases received and processed
monthly releases received and processed
Customer wise releases received in a month
Customer wise releases received in a Week
Releases processed by user week wise
Releases processed by user monthly
Monthly release trend
Please help…
Take a look at pivot table.
Most of your questions (maybe all of them) can be solved by pivot table.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
kesavanprabhu,
See if something below will help you:
How to create Excel Dashboards
http://www.mrexcel.com/Excel-dashboards-Xcelsius.html
http://www.contextures.com/excel-dashboards.html
http://chandoo.org/wp/excel-dashboards/
http://chandoo.org/wp/management-dashboards-excel/
http://www.exceldashboardwidgets.com/
http://www.andypope.info/charts/gauge.htm
Excel Dashboard / Scorecard Ebook
http://www.qimacros.com/excel-dashboard-scorecard.html
Mike Alexander from Data Pig Technologies
http://www.amazon.com/Excel-2007-Das...5564958&sr=1-1
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks