Advanced Excel Chart Skills

  • 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

    Continue reading

  • 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

  • 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

  • Creating a Monthly timeline Gantt chart with Milestones in Excel or PowerPoint

    How do you create a Gantt chart in Excel? You can create a Gantt chart to show project tasks and timelines in Excel using a stacked bar chart. You can include milestones if needed. By using a chart in Excel, when the dates of the tasks change, the Gantt chart is automatically updated. In this…

    Continue reading

  • Creating a Gantt chart with Milestones using a Stacked Bar Chart in Excel or PowerPoint

    When you need an accurate Gantt chart, you can use a stacked bar graph in Excel to create it

    Continue reading