Excel dashboards – XLCubed Blog ../../../ XLCubed Blog Wed, 08 May 2019 08:32:03 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Excel dashboards – XLCubed Blog ../../../ 32 32 2011 Dashboard Competition ../../../2011/09/2011-dashboard-competition/ ../../../2011/09/2011-dashboard-competition/#respond Tue, 27 Sep 2011 10:06:15 +0000 http://blog.xlcubed.com/?p=3125 A slight departure from the normal blogging to let everyone know about the latest developments in XLCubed and to talk about a new dashboard competition with the chance to win an iPad 2! Dashboard Design Competition XLCubed are sponsoring Dashboard Insight’s first dashboard design contest. The competition is based on a provided data set, and […]

The post 2011 Dashboard Competition appeared first on XLCubed Blog.

]]> ../../../2011/09/2011-dashboard-competition/feed/ 0 Heatmap Tables with Excel – Revisited ../../../2011/07/heatmap-tables-with-excel-revisited/ ../../../2011/07/heatmap-tables-with-excel-revisited/#comments Mon, 11 Jul 2011 10:42:55 +0000 http://blog.xlcubed.com/?p=2622 We’ve revisited one of our more popular guides Heatmap Tables with Excel as they can be a very effective way of presenting data on a dashboard, and have now updated it for Excel 2010… This Heatmap Table is designed to show you the revenues and the discounts of a company over the course of one year […]

The post Heatmap Tables with Excel – Revisited appeared first on XLCubed Blog.

]]> ../../../2011/07/heatmap-tables-with-excel-revisited/feed/ 13 Flexible time-series graphing from a slicer ../../../2011/07/flexible-time-series-graphing-from-a-slicer/ ../../../2011/07/flexible-time-series-graphing-from-a-slicer/#comments Tue, 05 Jul 2011 09:03:16 +0000 http://blog.xlcubed.com/?p=2559 We are often asked how to drive a chart from a slicer in XLCubed and how to plot days/months for a month or year. Base case this is fairly straightforward, you can set up a grid which is based on the previous ‘x’ months of a slicer selection for example. The difficulty can be where you want […]

The post Flexible time-series graphing from a slicer appeared first on XLCubed Blog.

]]> ../../../2011/07/flexible-time-series-graphing-from-a-slicer/feed/ 1 Gemini – Smarter Excel Dashboards with End-User BI ../../../2008/10/gemini-smarter-excel-dashboards-with-end-user-bi/ ../../../2008/10/gemini-smarter-excel-dashboards-with-end-user-bi/#comments Wed, 08 Oct 2008 23:29:58 +0000 http://blog.xlcubed.com/?p=589 I attended beginning this week the Microsoft BI Conference in Seattle where Microsoft presented an interesting new product that might change the way you build your Excel dashboards in the future: “Gemini”, an End-User Business Intelligence plug in for Excel. End-User Business Intelligence has been around for quite a while with some of the most […]

The post Gemini – Smarter Excel Dashboards with End-User BI appeared first on XLCubed Blog.

]]> ../../../2008/10/gemini-smarter-excel-dashboards-with-end-user-bi/feed/ 3 Excel Dashboard Competition: Bank Dashboard ../../../2008/08/excel-dashboard-competition-bank-dashboard/ ../../../2008/08/excel-dashboard-competition-bank-dashboard/#comments Mon, 11 Aug 2008 01:42:06 +0000 http://blog.xlcubed.com/?p=398 This blog post is the first in a series of blog post that features the winners of the 2008 Excel dashboard competition. “A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored at a […]

The post Excel Dashboard Competition: Bank Dashboard appeared first on XLCubed Blog.

]]> ../../../2008/08/excel-dashboard-competition-bank-dashboard/feed/ 2 The Dashboard Squint Test ../../../2008/08/the-dashbord-squint-test/ ../../../2008/08/the-dashbord-squint-test/#comments Sat, 09 Aug 2008 01:13:33 +0000 http://blog.xlcubed.com/?p=403 Before we go and review the 2008 Excel Dashboard Competition Winners I have to make you familiar with  the Dashboard Squint Test. Software usability experts and web designer use a quite effective way to assess the organization of a web page or a user interface, the so called Squint Test. You squint your eyes and […]

The post The Dashboard Squint Test appeared first on XLCubed Blog.

]]> ../../../2008/08/the-dashbord-squint-test/feed/ 2 The Missing Link (Part 1) ../../../2008/07/the-missing-link-part-1/ ../../../2008/07/the-missing-link-part-1/#comments Mon, 28 Jul 2008 06:52:34 +0000 http://blog.xlcubed.com/?p=334 Every good discipline needs a missing link. Evolutionary biology had a missing link between humans and the ‘lower’ animals. Physics has a missing link between quantum mechanics and general relativity. The Information Visualization community discovered the Missing Link Between Information Visualization and Art. Now we discovered the missing link in Excel Data Visualization. As we […]

The post The Missing Link (Part 1) appeared first on XLCubed Blog.

]]> ../../../2008/07/the-missing-link-part-1/feed/ 13 2008 Excel Dashboard Competition Winners ../../../2008/07/2008-excel-dashboard-competition-winners/ ../../../2008/07/2008-excel-dashboard-competition-winners/#comments Thu, 17 Jul 2008 01:50:25 +0000 http://blog.xlcubed.com/?p=289 After much deliberation and debate, we are pleased to announce the winners of the 2008 Excel Dashboard Competition. We were impressed by many of the entries, and thanks to all of you who entered. It’s good to see MicroCharts being put to effective use, and adding value in such a variety of business scenarios and […]

The post 2008 Excel Dashboard Competition Winners appeared first on XLCubed Blog.

]]> ../../../2008/07/2008-excel-dashboard-competition-winners/feed/ 5 Sharing your Excel dashboard: from paper to the web ../../../2008/05/sharing-your-excel-dashboard-from-papel-to-the-web/ ../../../2008/05/sharing-your-excel-dashboard-from-papel-to-the-web/#comments Wed, 28 May 2008 23:00:00 +0000 http://blog.xlcubed.com/?p=43 You have finished your great looking, very efficient Excel dashboard. Now, how do you share it? How do you make sure the users have a timely access to the latest update? This can be a serious issue, specially if you have a more tech oriented audience, and it must be addressed at the planning stage. […]

The post Sharing your Excel dashboard: from paper to the web appeared first on XLCubed Blog.

]]> ../../../2008/05/sharing-your-excel-dashboard-from-papel-to-the-web/feed/ 3 Data sources for Excel dashboards: avoid spreadsheet hell ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/#comments Sun, 25 May 2008 23:00:20 +0000 http://blog.xlcubed.com/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/ This is the first of two twin posts where we’ll discuss the alpha and omega of Excel dashboards: data access and dashboard publication. These are two weak areas in Excel, and they should be approached carefully when planning for a new dashboard. Let’s start by reviewing the available data access options. Copy / Pasting data […]

The post Data sources for Excel dashboards: avoid spreadsheet hell appeared first on XLCubed Blog.

]]> ../../../2008/05/data-sources-for-excel-dashboards-avoid-spreadsheet-hell/feed/ 3