Excel dashboard for location

[ushaanu]

hi all excel guru ,

i have 4 branch data in my excel sheet like financial and Service.I don't under sand how out these data in proper dash board so that month on month review data shows clear & looks dashboard like if i am looking some branch performance so i choose the branch .

i am enclosing the data file .i put example one month data only for example .

thank
Anu.

 

[Hui]

Anu

Firstly, I apologise about the previous note as we are experiencing some technical issues with the forums and this may have caused you to double post by mistake.

To attack your dashboard:

I would recommend that you start by examining other dashboards on this site to get some ideas about layout and style

In regards to implementing a dashboard, that depends on what story you want to tell whoever the dashboard is targeted at.
Talk to the audience for the dashboard and understand what is important for them and what isn't

Next, start by reading the following posts:
http://chandoo.org/wp/excel-dashboards/

Each section is packed with examples and other reading

Then come back here when you have an idea of what you want to do and have collated the data and have an idea of what you want to achieve

 

[ushaanu]

df