Advanced Excel Chart Skills

  • 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… Continue reading Overlapping bar progress graph

  • 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… Continue reading How to create an Excel chart with a dynamic range that you select

  • 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… Continue reading Add-ins/Web tools for Excel charts

  • 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 for the audience… Continue reading Bar charts with long category labels; Issue #428 November 27 2018