Hello, some one asked me to upload this workbook, so here it is.
All respect goes out to https://www.excelforum.com/ and its users for providing the formulas needed for the dashboard.
Special thanks to Jonmo1 , FDibbins, sandy666, AlKey, shg and Andy Pope .
This was designed for a display dashboard. If one needs to print it, one will need to take a picture of the dashboard and use a paint software like https://www.getpaint.net and invert the colors. So, basically what that gonna do is make it from black and white to white and black.
In order to look like this (picture down below)
step 1 take a picture of the display (PrtScn button)
step 2 past it in ( ctrl + v)
step 3 invert the colors
step 4 adjust the white level
step 5 squeeze the image size
Last edited by sovietchild; 04-13-2017 at 01:13 PM.
Thank you for the upload. That is a really cool dashboard!
Dave
sovietchild, Many thanks for uploading your work that supports your dashboard. Will be studying it to learn some new techniques.
In order to look like this (picture down below)
step 1 take a picture of the display (PrtScn button)
step 2 past it in ( ctrl + v)
step 3 invert the colors
step 4 adjust the white levels
step 5 squeeze the image size
Last edited by sovietchild; 04-13-2017 at 01:12 PM.
Here is a simple dashboard if anyone wants it.
Simple concept. (imitated from google images search through dashboards)
If anyone wants it.
Last edited by sovietchild; 07-10-2017 at 06:47 PM.
Very nicely done!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is a simple dashboard that could go well with how products are doing week to week or month to month.
Attachment 534405
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks