Advanced Excel Chart Skills
Featured Articles
All Articles
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...
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...
VBA Programming to work with Excel charts
Excel MVP Jon Peltier’s articles on VBA Excel MVP Chandoo’s VBA courseThe 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...
Bar charts with long category labels; Issue #428 November 27 2018
How do we create graphs with category labels that contain a lot of text? If you are comparing values to each other, a column graph can get tricky since Excel and PowerPoint will turn the text at an angle and cut off labels that are really long. This makes it very hard...