Advanced Excel Chart Skills
-
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…
-
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…