Home > Data > Dashboards > Survey Excel Dashboard ProblemsOn my Contextures blog, I asked if people used Excel Dashboards - Yes or No, and what problems they encountered, if they used dashboards. The detailed results and replies are shown below, and you can also see my summary of these results in the embedded Excel workbook, below all of the replies. Do any of these dashboard problems sound familiar, when you work in your Excel dashboards? |
Use Excel Dashboards Yes or NoThere were 58 replies to the survey, with a large majority saying Yes, they do use dashboards in Excel.
To get those totals and percentages quickly, I built a pivot table, to count the Yes and No replies. The "Built a Dash" field is in the pivot table 3 times:
|
What Type of Excel Dashboard Problems?For those who replied Yes in this dashboard survey, I asked them to add a comment about the type of problems they encountered when working with Excel Dashboards. I've listed their comments below, grouped into broad categories. As you can see, the biggest group is Layout problems, with 25 comments (61%). It's hard to find the best way to present all that data!
And here's a screen shot of the pivot table that I created, to get those category totals and percentages. You can also see this pivot table in the embedded Excel workbook, below all of the replies. |
Dashboard Layout ProblemsHere are the comments that I included in the Layout problem category.
|
Dashboard Data and Formula ProblemsHere are the comments that I included in the Data, Updating, and Formula problem categories.
Dashboard Charts and Interactivity ProblemsHere are the comments that I included in the Charts and Interactivity problem categories.
Other Dashboard ProblemsHere are the comments that I included in the other problem categories - Skills and Automating.
|
Dashboard Survey Results in ExcelHere is an interactive workbook that shows the results from comments in our Excel Dashboard survey. You can download a copy of this Excel file in the section below. Get the Excel WorkbookTo see all the survery replies, and my pivot table summaries, you can download the Excel dashboard survey results workbook. The zipped Excel file is in xlsx format, and it does not contain any macros. |
Learn More About DashboardsAnd if you want to improve your Excel dasboard skills, I highly recomment Mynda Treacy's Excel dashboard course. There's are free dashboard webinars that you can watch, to see if Mynda's teaching style is a good fit for what you need. |
Last up September 14, 2023 11:34 AM dated: