A few years ago I shared an approach that you can use to extract data from an Excel chart that won’t allow you to view or edit the data. This happens when a chart is pasted from Excel onto a slide using the normal Ctrl+V paste method. The data is linked back to the...
One of my most popular Excel Chart Tips videos is the one on conditional formatting of a column chart based on the values being categorized into ranges (video is here). Another option for conditional formatting is to visually focus the audience on one (or more) column...
On a recent AFP webinar discussing what CEOs and Boards are expecting from the Finance department during these turbulent times, cash flow forecasting was clearly the biggest request. It was clear that finance teams are having to generate multiple future scenarios...
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...
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...
Basic Excel Chart Skills Intermediate Excel Chart Skills Advanced Excel Chart Skills Training Workshops Excel Chart Articles Videos & Online Courses 25 Advanced Excel Chart Tips and Tricks (video) These 25 tips and tricks will help you take your skills in creating...
Free mini-course: Presentation-Ready Excel Charts That Are Easy to Update and Re-use
Guided Self-Study Course
This course is ideal for those who want to learn how to improve their presentations but don’t have the opportunity to arrange an in-house customized session.