• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Suggestion and Improvement ideas

Sandeep H C

New Member
Hello I have created the dash board for analysis of Process and Cost and Yield of the production process. Please help me in improving.
 

Attachments

  • ColorButtons_PW1_Final.xlsx
    290.8 KB · Views: 9
Sandeep

Firstly, Welcome to the Chandoo.org Forums

There is nothing wrong with your dashboard at all

You may want to look at using sliders for the controls instead of List box as it makes it more interactive

You may wish to Hide Columns K:XFD and Rows 40:1048576
so that the user can't move around like below:
upload_2015-4-9_12-17-51.png
 
Hi Sandeep ,

To add to what Hui has posted , the dashboard is not making use of all screen space. Roughly , 40% of the screen , on the right side is unused.

If the section of the dashboard which is down below can be accommodated on the right , the entire dashboard can be presented without the user having to scroll down to view the section below.

Secondly , I would like to know why there are the Year , Month and Day listboxes , instead of using a simple Data Validation dropdown which has dates.

Separating the 3 components of a date is meaningful only if you have the mechanism for consolidating and presenting the output based on the selections made ; e.g. if a person selects only the Year , then a summary for the entire year is presented , if a person selects the Year and the Month , then a summary for the entire month is presented , and if a person selects all 3 components , then the data for the selected date is presented.

If you are not doing this kind of presentation , then having the 3 components individually is not correct ; having a single DV dropdown which allows the user to select any desired date , makes it clear that what ever data is presented is for the selected date.

Narayan
 
Narayan Thank you so much for your valuable input.

Yeah I will try to utilize the right side part of worksheet. By doing this the user need not to scroll down for to view sections below.

The idea behind the list box is as the dashboard is created for the daily data. So If I put the Data validation by giving a list of dates it will make more work to update the list.

Please help me with how to do this "Separating the 3 components of a date is meaningful only if you have the mechanism for consolidating and presenting the output based on the selections"

Please guide me if this doesn’t make sense.
 
Thanks a ton Hui,I was looking the Control forms with other options than List box. I will look and use Sliders can you give dummy file where sliders are used.

I will hide the Columns and rows that helps user as you suggested.

Thank You Very Much.
 
See attached file:
 

Attachments

  • ColorButtons_PW1_Final.xlsx
    289.7 KB · Views: 9
Right click on it
Format
Then follow the Link To cell
You will see how I connected it to your existing model
 
Yeah i gone through.


Hui is there any alternate way for this to handle dates.
Because if i select the year and month (eg:Feb) Date values has to be filtered by 28. Is there any possible way or any other date handling plugin or method if you know please share it.
 
Quick question on the data page any reason you are working left to right in your data? Utilizing a table object would infinitely open up the potential of this document. Just some feedback.
 
Alex Powers: I was new to Dashboard creation and using offset function.

For calculation purpose that is to get the data values i used the data in Left to right... I have used the Match function to get the column number of the data based on the date.

I did not searched to find the function to get the row number so that i can use the from top to bottom. I mean table (transaction format) of data.


Thanks
sandeep
 
Back
Top