+ Reply to Thread
Results 1 to 10 of 10

Dashboard workbook

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Dashboard workbook

    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 .


    Name:  7.0 Classie template.png
Views: 2271
Size:  143.4 KB
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    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

    Name:  IMG_1717 (1).jpg
Views: 2149
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:13 PM.

  3. #3
    Forum Expert
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    6,338

    Re: Dashboard workbook

    Thank you for the upload. That is a really cool dashboard!
    Dave

  4. #4
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    76

    Re: Dashboard workbook

    sovietchild, Many thanks for uploading your work that supports your dashboard. Will be studying it to learn some new techniques.

  5. #5
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    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

    Name:  IMG_1717 (1).jpg
Views: 2264
Size:  1.52 MB
    Last edited by sovietchild; 04-13-2017 at 01:12 PM.

  6. #6
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    Here is a simple dashboard if anyone wants it.

    Name:  Untitled.png
Views: 2263
Size:  86.1 KB
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    Simple concept. (imitated from google images search through dashboards)

    Name:  CONSEPT.png
Views: 2260
Size:  36.2 KB
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    If anyone wants it.

    Name:  Cos.png
Views: 1118
Size:  179.2 KB
    Attached Files Attached Files
    Last edited by sovietchild; 07-10-2017 at 06:47 PM.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    41,059

    Re: Dashboard workbook

    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 some-1 helped you

    Regards
    Ford

  10. #10
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    130

    Re: Dashboard workbook

    Here is a simple dashboard that could go well with how products are doing week to week or month to month.

    Attachment 534405
    Attached Images Attached Images  
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1