Category Archives for "Excel – Dynamic Dashboards and Charts"

Download the Top 25 Dashboard Design Tips Sheet

Excel , Excel - Dynamic Dashboards and Charts , Top Tips

A lot of readers were interested in the Top 25 Best Dashboard Design Tips article. It had the second highest newsletter readership. To make it easier to access these tips when you design dashboards, just click here to download a PDF with links, Top 25 Best Dashboard Design tip sheet. Keep it in your “Best Practices” […]

Read More

Top 25 Tips on Excel Dashboards

Excel , Excel - Dynamic Dashboards and Charts , Top Tips

This is a collection of tips that will help you create powerful Excel dashboards. This ranked list started by collecting the top Excel dashboard tips from multiple search engine pages. After aggregated the tips I ranked them for usefulness based on 30 years of experience developing Excel dashboards and strategic performance projects. 1. Talk to Users. Build […]

Read More

Would You Like to Spy on Your Neighbor’s Dashboards? Here’s How.

Excel , Excel - Dynamic Dashboards and Charts

Have you ever wanted to see how others have designed a dashboard? Or what another organization’s Balanced Scorecard looks like? Come on. I know you have. Why learn things from scratch when you can stand on the shoulders of other good ideas. Seeing how others approach a problem can show you where you forgot something […]

Read More

Top 5 Excel Funnel Charts Sales and Marketing Love — One Funnel Chart You Should Never Use — And Two Dynamic Funnel Charts in PowerPoint!

Excel , Excel - Dynamic Dashboards and Charts , Top Tips

This blog will show you five different ways to make funnel charts in Excel and two ways to link Excel funnel chart data into PowerPoint slides. Funnel charts are a favorite of marketing and sales for showing the volume and progress through different stages of the customer journey, from initial contacts, to qualified leads, to prospects […]

Read More

Use an Excel Pareto Chart to Improve Business Impact and Performance

Excel , Excel - Analytics , Excel - Dynamic Dashboards and Charts

There are two or three charts that every business person must know. One of those should be the Pareto Chart. This chart is the god of productivity improvement. Pareto’s Rule, and its chart, shows you where small changes in your business create huge impacts. This tip will show you how spending five minutes with an Excel […]

Read More

Top 25 Best Excel Dashboard and Chart Tips for 2015

Excel , Excel - Dynamic Dashboards and Charts , Top Tips

Tony Robbins and other performance gurus who strive to improve personal performance teach that one of the most powerful ways to improve ourselves is by modeling. Modeling is watching others so you can learn how they perform a task better, then modeling our behavior after theirs. These are the top 25 best Excel dashboard tips […]

Read More

Top 30 Best Excel Chart and Dashboard Tips in the “Excel Chart and Dashboard Quick Reference Guide”

Excel , Excel - Analytics , Excel - Dynamic Dashboards and Charts , Top Tips

Get your free copy now of the Excel Chart and Dashboard Quick Reference Guide. Quick Reference Excel Charts and Dashboards – US Letter Quick Reference Excel Charts and Dashboards – A4 Critical to Success now has over 4,000 subscribers with 72% of you consistently opening and using its tips and tools. That is so Awesome! It makes me […]

Read More

Microsoft Excel 2016 Charts and Analytics: Are You Ready? Can You Wait?

Excel , Excel - Dynamic Dashboards and Charts

Microsoft Excel 2016 was released September 22, 2015. Do you need its new charts and a few analytics gadgets it has added? I’m not so sure. However, if you work with teams there are some enterprise collaboration features that will make life less frustrating. (It works on Windows 7 SP 1 or later.) Overall, the […]

Read More

Vertically Scrolling Dynamic Sparklines Alongside a Database

Excel , Excel - Dynamic Dashboards and Charts

This Excel tutorial combines INDEX and Sparklines to create a window of vertically scrolling data and scrolling Sparklines. The “scrolling window” looks into a much larger database. The result is a very functional reporting technique that is cool and takes little space in Excel reports or dashboards. If you put the large database in a […]

Read More

How do Sparklines work with Non-Numeric or Hidden Data?

Excel , Excel - Dynamic Dashboards and Charts

Make sure you know how Sparklines work when their range includes non-numeric or hidden data. The data in the cell is the Sparkline Non-numeric ignores data and plots through non-numeric #NA ignores #NA and plots through #NA Blanks plots a blank Zero plots as zero Empty cells shows empty cells as you specify. See below. […]

Read More
1 2 3 7