What can you do if you want to create a chart but the values you have differ by an order of magnitude or more? If you use the standard column or bar graph, you risk the smaller values being virtually invisible because the chart is scaled to show the large values. In my customized workshops…
Tag: 2020
Creating non-standard shapes; Issue #459 March 3, 2020
In a previous newsletter I showed how using semi-transparent shapes to show categories or groups of items can help explain a complex diagram or image. In the example, I used rectangles because the groups of items were located neatly beside each other. What if the items you want to group are not in a neat…
Scaling values for related data series; Issue #458 February 18 2020
It is not uncommon that to communicate a message you need to show two or three related data series. It is relatively easy to create a single graph that has all the data series shown. The challenge comes when you have values in the data series that are different by an order of magnitude or…
Test slides when using video wall; Issue #457 February 4 2020
As more conference rooms move from using projectors to using monitors to display presentations, an issue is coming up in larger rooms. While a single large monitor will work in a small to medium sized room, it is too small for a medium to large sized room. To create a larger display, organizations install a…
Excel file name affects linking to PowerPoint; Issue #456 January 21 2020
In this newsletter I shared how one single character in an Excel file name caused linked cells and graphs in PowerPoint to fail. This is an article that I originally posted in my CreateExcelCharts sub-site here.
PowerPoint Presentation Best Practices Audit; Issue #455 January 7 2020
The start of a new year is a common time to evaluate where you are and what you want to improve to make this year better than the previous year. If you are looking to make more effective PowerPoint presentations in 2020, I suggest you start with my Effective PowerPoint Presentation Audit. In this audit…