This post is part of Excel Dashboard Week
As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto.
Health-care Dashboard Snapshot:
[Click here to view large version]
How is this Dashboard Made? – An Overview:
Alberto put together an excellent dashboard to visualize hospital performance and understand what is going on.
Here is what I like about the dashboard:
- Clear title and ability to select which half-year you want to analyze.
- Subtle colors for non-data elements of the dashboard
- Alerts to highlight focus areas
- Clear and simple to read dashboard. Once you understand how to read the first line, you know how to read the rest.
- Sparklines, Conditional Formatting.
What can be improved in this dashboard?
- Formulas: Alberto used IF formulas to fetch the values for each half-year (semestre). Instead using INDEX or OFFSET would make his job simpler.
- Hardcoded targets: The target values for each metric are hard-coded. Instead, they should be put in a separate table, just like actual data.
- Solid Fill bars: Instead of using gradient fill data bars, it is better to use solid fill bars thru in-cell charts.
How is the dashboard constructed? – An overview Video:
I have made a short video to explain this dashboard to you. Watch it to understand how this dashboard is made and how you can use similar techniques.
Download the Health-care Dashboard Workbook
Click here to download the excel workbook for the Health-care Dashboard.
Thank you Alberto
I am really thankful to Alberto for taking time to share this file with us so we all can learn from his work.
If you enjoy this Dashboard, say thanks to Alberto.
Contribute to Excel Dashboard Week:
Share dashboard tips, snapshots, excel workbooks or links by filling out this simple online form. Go ahead and share what you got so that we all can learn from each other and become awesome.
Learn How to Make Excel Dashboards:
If you wish to learn how to make Excel Dashboards, join my Excel School online training program. We have 4 completed dashboard tutorials that teach you how to make a KPI dashboard, a Sales dashboard, a Business dashboard and a Website dashboard, all using MS Excel.
Click here to join Excel School program.
11 Responses to “Use Alt+Enter to get multiple lines in a cell [spreadcheats]”
@Chandoo:
One more useful trick.......
In a column you have no. of data in rows and need to copy in the next row from the previous row, no need to go for the previous rows but entering Alt + down arrow, you will get the list of data, (in asending order), entered in the previous rows...
This is another great tip. I use this all the time to make sense of some *very* long formulas. As soon as the formula is debugged I remove the break.
Great tip Chandoo!
I use this feature often and it has even gotten the, "how did you do that" response.
Thanks!
@Ketan: Alt+down arrow is an awesome tip. I never knew it and now I am using it everyday.
@Jorge, Tony: Agree... 🙂
[...] Day 1: Insert Line Breaks in a Cell [...]
how can we merge a two sheet.
excellent idea. Chandoo you are genious
Hi chandoo,
I have used ctrl+enter to break the cell. But I did not get the result.
Please tell me how can i break the cell in multiple lines.
Hi, Ranveer,
Its not Ctrl+enter to break the cell, use Alt+Enter to make it happen.
hi Chandoo....
how we can use Alt+Enter in multiple rows at the same time please reply hurry i have lot of work and have no time and i m stuck in this. 🙁
Alt+J worked once 🙁
So I found another more reliable way:
=SUBSTITUTE(A2,CHAR(13),"")
Where A2 is the cell that contains the line breaks which the code for it is CHAR(13). It will replace it with whatever inside the ""