Advanced Excel Chart Skills
-
Use the INDIRECT function to create similar charts in Excel quickly and easily
Recently I’ve been sharing a technique in my client training that increases the payoff for making the effort to create a meaningful chart in Excel. Often we have results for different locations, regions, products, or scenarios to show. We don’t have to compare them to each other, but, for example, each region needs to report……
-
Overlapping bar progress graph
One of the common messages reported in financial or operational reports is progress towards a goal. It could be a spending goal, production goal, or any other important metric that is tracked. The decision makers want to see the goal, where we expected to be at this time, and actual progress. Instead of the typical……
-
How to create an Excel chart with a dynamic range that you select
Basic dynamic charts A standard chart in Excel uses a defined set of cells for the category axis and the data values. This works for most charts. But what if you want to create a chart where the data range gets bigger or smaller based on criteria? That is where you will want to create……
-
VBA Programming to work with Excel charts
Excel MVP Jon Peltier’s articles on VBA Excel MVP Chandoo’s VBA course The Mr Excel forum is a good place to ask Excel VBA questions
-
Add-ins/Web tools for Excel charts
Jon Peltier’s Excel chart add-in at https://peltiertech.com/Utility30/ When you are considering using an add-in for Excel, always remember to check with your IT department to make sure it approved and allowed to be installed on a corporate computer. Also make sure that the charts it creates will be in the current chart format so others can……