Excel Dashboard Tips
August 04, 2015
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
During the summer months I'll publish the newsletter once every two weeks, so you will get the next issue on August 18th.
In the last newsletter, I asked for your opinion in a short survey, and thank you for all the responses (133 so far). As expected, most of the respondents use Windows (97%), but results for the other two questions might surprise you.
To see all the details, you can download the workbook from my Contextures website. Go to the Sample Files page, and in the Pivot Tables section, look for PT0041 – Show Survey Results in Pivot Tables.
Instead of putting several charts and data tables on a dashboard, you can add let people choose what they want to see. Add a drop down list of items, along with a linked picture. Then, choose an item in the drop down list, and that items is shown in the linked picture. This saves space on the dashboard, and doesn't require macros.
Here are a couple of Excel articles I read recently, that you might find interesting and useful.
Seating Chart -- If you have to organize table seating for an event, download the Excel Seating file from Oz du Soleil's blog. You can specify which guests don't want to sit at the same table, and who insists on sitting together. This will be a big help if you're planning a family reunion, or wedding, or company party. Excel will help you keep everyone happy. ;-) (Level - Intermediate)
Dashboard Color Scheme -- When you're creating a dashboard, choosing a color scheme can be tricky. You want the dashboard to look good, but you don't want to spend hours playing with different color combinations. To make the task easier, download a copy of Mike Alexander's free Color Scheme Selector workbook. It has 75 combinations set up, and you can add your own. (Level - Intermediate)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog.
Excel Dashboard Course: Mynda Treacy has opened registration for her acclaimed Excel Dashboard course, and the deadline is this Thursday, August 6th. The course is a great investment, and you can read my review for the highlights, and more information.
Free Dashboard Webinars: Mynda is also offering two free one-hour webinars -- 1) How to Build Excel Dashboards, and 2) Dashboards with Power Query and Power Pivot. Get the details, and sign up for a date and time that is convenient for you.
The weeds were taking over my back garden this month, until my son stopped by for a visit, and cleared them all out. When he was finished, I snapped a photo of the nice, tidy garden. That reminded me of a long ago picture, when he also liked to help me in the garden, but wasn't quite good at pulling weeds!
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: https://www.contextures.com/newsletter/excelnews2015/20150804ctx.html
That's it for this week! If you have any comments or questions, send me an email.
[email protected] contextures.com
Last updated: December 27, 2019 12:10 PM