Gauge charts are not a standard chart in Excel and are quite complex to create. Gauge charts should be avoided for dashboards.
Dashboard Charts are the ultimate goal of most Power BI reports, so let’s dive in.
In the previous post we extracted the data from a CSV file. Now let’s create a report. It won’t be the greatest report as the data is pretty basic, but at least its a start.
Check out my follow up article and VIDEO on the ITBDigital website on how to convert a vertical bullet chart into a horizontal one.
For the original bullet chart post click here
These techniques are based on ones in the great book
Excel 2007 Dashboards and Reports For Dummies by Michael Alexander
Check out my July 2014 article on Bullet charts on the CPA Australia ITBDigital website – click here to see the article. The video is below.
Bullet charts were developed by Stephen Few – see his pdf on bullet charts click here.
The technique is based on one used by Michael Alexander in his great book Excel 2007 Dashboards and Reports for Dummies by Wiley.
When building dashboards in Excel you frequently need to have multiple charts that are exactly the same size. Luckily Excel makes this reasonably easy to achieve.
Line charts are frequently used in Excel but their default settings leave a lot to be desired. See the transformation of a standard line chart to a simpler and easier to read line chart.
It’s easy to move and re-size charts on a sheet. It’s a different story when you want to include small reports on a dashboard. Reports are affected by the existing row heights and column widths.
Text boxes are flexible because you can place them anywhere on your spreadsheet.
You can link a text box to the contents of a cell.
Excel’s Sparkline Charts
Sparkline charts are a new feature in Excel 2010. Sparkline charts are small cell-sized charts that are designed for dashboard reports. The chart sits inside a single cell and its size changes with the size of the cell, both height and width.