Contextures

Contextures News 20150804

Excel Dashboard Tips

August 04, 2015

Results from our Excel survey, dashboard tips, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Summer Schedule

During the summer months I'll publish the newsletter once every two weeks, so you will get the next issue on August 18th.

Excel Version Survey Results

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.

  • Most people are using Excel 2013 (61) or 2010 (53), but 2 people are still in Excel 2003!
  • The overall "Like" score was quite high -- 7.9 -- so that's good news. If you spend all day in a program, it helps if you like it.

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.

Show Chart or Data on Dashboard

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.

select chart from drop down list

Excel Articles

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 Announcements

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 Garden Helper

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!

weekly photo

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.

Debra Dalgleish
[email protected] contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Last updated: December 27, 2019 12:10 PM