Category Archives for Dashboards
Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide
IntroductionI wanted to let you know about a really cool new add in for Microsoft Excel. This is one of those modern add-ins you can download from the Microsoft store. This add-in can allow you to easily create hierarchy type process maps and flow charts. The free version creates standalone type charts. The paid version, the […]
Continue reading
Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut
IntroductionI built a chart that let’s you highlight a series from a smaller chart (take a look at that the chart under the timeline) and show it in more detail on a larger chart. Yahoo! Finance used to have something similar, although I can’t find it anymore. But anyone who has looked up stocks online […]
Continue reading
Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks
No matter where you fall on the political spectrum, you’ll love the chart I’ve created, which you can adapt and use in your own work. The instructions are a bit complicated, so rather than go through every element with figures, I’ve written up what I would do assuming you’re watching and following along in the […]
Continue reading
Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54
CORRECTIONSeveral people pushed back on the video I release this morning and I want to thank them (and in particular Wim Gielis). This caused me to open my laptop on the train while on the way to a client’s office (so I could see if I was wrong … which I was!). When I realized […]
Continue readingSorting in Excel Dashboards
We all aware of harnessing the power of VBA to dynamically sort dashboards based on user input. But is there a simpler, more elegant solution? Yes, there is. And Excel MVP Jordan Goldmeier is here to solve this mystery for us. Let’s dive in! 1 – The Excel Dashboard Data The image below shows an […]
Continue readingExcel Requests – HTTP for Humans
Written by Bjoern Stiel APIs are the lifeblood of the internet, providing access to bits and bytes that make our personal and professional worlds work. For example, Quandl provide a vast amount of financial and economic data through their API, while GitHub and StackOverflow let you pull out all sort of user and repo data through their API. But how do we communicate […]
Continue readingHow To Fix Ugly Political Dashboards
It’s time to be brutal! And political-themed dashboards will take the brunt of it. With Szilvia facilitating the session, Jordan, Rick and our special guest Brad Edgar discuss the merits of various dashboard designs. Let’s get started! 1 – Readability Issues It’s easy to get carried away when it comes to designing dashboards. And this […]
Continue readingDynamic Labels – Excel Dashboards Tips
Many a times we want to include chart titles in our dashboards, but we don’t since they are not dynamic. If your user changes some filters, you would want your pivot chart titles to update automatically. Well, there is a way to actually do that, to make these chart labels truly dynamic. And Excel MVP […]
Continue readingExcel Prevent Buttons, Shapes and Objects from Resizing – Excel Tricks
Are you fond of using Dashboards in Excel? I know you would say “Yes” and why not everyone likes it. It is one of the beautiful things that can be done using Excel. So, we would have many objects to make Dashboard looks pretty. In that, we would want to insert a header, new rows […]
Continue readingExcel Requirements Gathering Process – Excel Dashboards
Excel consultants know that requirements gathering exercises can look deceptively simple. Whether that be for creating a dashboard for the client or an Excel application, there is always something in hindsight that one could have done better. Let’s not depend solely on our own mistakes to become better Excel consultants. Our in-house team of Excel […]
Continue readingMichael Alexander – Bacon Bits Blog – Excel Expert Interviews
Excel MVP Michael Alexander of the Bacon Bits Blog at http://www.datapigtechnologies.com/blog/ discusses how his blog began and his work with Szilvia on the Excel themed cocktail book. DataPig Blog Rick: Talk about DataPigTechnologies and your blog? Michael: Bacon Bits Blog is my blog I started in 2009 as a way to sell Boot Camp. […]
Continue readingAuto Resizing an Excel Spreadsheet For Your Dashboard
Do you know that Excel allows us to zoom to a specified area in your work sheet? Yes, you heard it right. Suppose, you have an Excel sheet and while doing demo or so, you want to zoom to specified area, it can be done easily. Our very own Excel MVP Jordan Goldmeier lets us […]
Continue reading
Three Common Dashboard Mistakes
I recently contributed to the article on MRC’s Cup of Joe Blog called 7 harmful business dashboard mistakes. I’ll excerpt a version of what I said below, but you should follow the link to read the whole thing. (I’ll use the original version I sent to blog so as not to compete for search keys.) I’ll […]
Continue readingFixing Excel Dashboard Blunders – with Excel MVP Mynda Treacy
Mynda Treacy runs a successful online Excel Training program (at http://myonlinetraininghub.com ) with course topics ranging from Power Pivot to Excel Dashboard development. Mynda joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier to discuss Excel Dashboard Blunders and WWMD??? (What Would Mynda Do?) First, Excel […]
Continue readingDynamically Select Different Chart Types – Excel Dashboard Tips
Most of us employ Excel to analyze data in search of some insights. For us, this is an enjoyable step. The not-so-pleasing step is the one that follows data exploration: presenting our findings. It is not an easy job to decide which chart-type will depict our analysis in the best possible way to the end […]
Continue reading