- Charting Shortcuts
- Bar Chart
- Column Chart
- Animated Charts
- Cycle Plot Chart
- Toggle Chart Series
- Toggle Chart Series without VBA
- Toggle Excel Chart
- Waterfall Charts
- Dynamic Updating Chart
- Update Chart from Dropdown
- Dynamic Updating Chart with VBA
- Remove Chart Series
- Remove Zeros from Charts
- Chart Hyperlinks
- Chart Hyperlinks Part 2
- Change Chart Bar Colour
- Group Items in Chart
- Heat Map in Excel
- Change Chart Series Colour
- Change PlotArea Colour
- 12 Month Rolling Chart
- Start End Chart for Excel
- Animated Heat Map in Excel
- Toggle Chart Using an Excel Slicer
Excel Charts and Fun
The following are the articles relating to Excel charts within the site. I do plan to add to this list. There are a number of concepts in the Dashboard section of the site which showed some handy charting techniques. Not all of these are covered in this section.