Percentage Area Chart in Excel
You can use a pie chart to display a percentage, but it wastes a lot of space. An alternative that takes up less space is an area chart.
(more…)
Free Excel Webinar Recording – Financial Functions Part 2
In July 2019 I explained and demonstrated a number of Excel's financial functions - see below for more details. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/349593208 In July 2019 following on from the response and feedback from my June webinar, I covered more financial functions. These are more related to comparing and…
Free Excel Webinar Recording – Financial Functions Part 1
In June 2019 I explained and demonstrated a number of Excel's financial functions - see below for more details. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/341487244 These functions take three or more arguments, but there are a few things you need to know to use them correctly. Most involve loans or calculations…
Free Excel Webinar Recording – Dashboard #1 Guildelines & Techniques
In May 2019 I examined and demonstrated some guidelines and techniques for creating charts for dashboards. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/334821126 In this session I focused on chart and dashboard guidelines plus some techniques used to create small charts for dashboards. I also looked at creating a bullet chart, which…
Vote No for Gauge Charts
Gauge charts are not a standard chart in Excel and are quite complex to create. Gauge charts should be avoided for dashboards. (more…)
Power BI – A Chart
Dashboard Charts are the ultimate goal of most Power BI reports, so let’s dive in. (more…)
Creating a Report in Power BI
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. (more…)
Re-Sizing Charts In Excel
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. (more…)
How to Improve an Excel Line Chart
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. (more…)
Flexible Dashboard Technique for reports
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. (more…)
Creating Dynamic Text Box entries in Excel
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. (more…)
New Sparkline Charts in Excel 2010
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. (more…)