• 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.

data dashboard

ushaanu

Member
hi all,

I have some data I m not understand how to manage to show all info in single sheet ,

sample file enclosed.

Thanks
Anu
 

Attachments

  • Sample.xlsx
    11.9 KB · Views: 5
Anu

My 2 cents worth is

1. Don't merge cells eg: B8:B10
every cell should have its own value

2. If A2 applies down to A7 put Sam in every cell,
every cell should have its own value

3. Don't leave blank cells B3
every cell should have its own value

4. You have left no room for expansion ie: Mar to Dec
Plan for the future, blank columns are ok as long as the layout is logical

5. Keep fields in logical order, ie Jan Profit should be before Feb profit, not after it.
 
Back
Top