+ Reply to Thread
Results 1 to 9 of 9

Dashboard creation needed

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Question Dashboard creation needed

    Hi i am a novice when it comes to excel as I have no concept of databasing or macros, hence some previous posts within this forum.

    I have been given a project to create a sales dashboard in excel, god knows why me....lol, but have no idea where to start.

    Is there anybody out there willing to help in the creation of this dashboard and to show me how thing work within it.

    I can supply some data and a design id like it look like.

    Please post here or message me direct if your interested in helping

    SORRY ADMIN IF THIS DOESNT CONFORM TO RULES BUT I THOUGHT 'GENERAL' WOULD BE THE BEST PLACE TO START. iF IT IS IN THE WRONG PLACE CAN YOU POST WHERE I NEED TO POST IT

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Dashboard creation needed

    ukphoenix,

    See:

    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
    Excel 2007 Dashboards & Reports For Dummies
    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.

  3. #3
    Registered User
    Join Date
    12-05-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Dashboard creation needed

    Guys I need help to create a chart/diagram/dashboard; I'm not sure what it's called it's simply a visual illustration of results... it looks like this:

    Dashboard.png

    I'll need a way to be able to program the data in it along with colors & degrees for each percentage

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Dashboard creation needed

    Welcome to the Forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.


    In you new thread explain why the 84% section is split into 3 and what do the gaps represent.
    A donut chart will produce the effect
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    12-05-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Dashboard creation needed

    Dear Andy, thanks for your prompt response... actually it's my first time ever to use a forum, so sorry if I didn't follow the rule.

    Moreover I think what I'm looking for is more like a dashboard widget rather than a donut chart.. the gaps don't represent anything, this widget is led by color identification & 4 levels for each color; so for example yellow is 80 to 90; and the 10 points from 80 to 90 are represented by 4 bards (2.5 points for each bar)... then Green is for 90 to 100 & so on.... The picture I sent isn't accurate as it should've been only 2 yellow bars based on my hypotheses but I shared it just to convey the idea...

    Please help...

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Dashboard creation needed

    I'm suggesting the donut chart can be used to create the widget.
    You have multiple data points whos value will be determined by formula, giving the colour variation.

    As I said start your own thread and provide more detail if you still need help.

  7. #7
    Registered User
    Join Date
    12-05-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Dashboard creation needed

    Dear Andy, how do I create a new thread?

  8. #8
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Dashboard creation needed

    Here you go Profsaid

    New Thread.PNG
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  9. #9
    Registered User
    Join Date
    12-05-2012
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Dashboard creation needed

    Thanks Kevin, I've created a new thread... appreciate your prompt response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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