Dynamic and Interactive Charts.

Introduction

Dynamic Charts

• Dynamic Column Chart
• Another Dynamic Chart
• Chart the Last 12 Months
• Dynamic Charting By Dates (TechTrax Article)
• Charting Dynamic Normalized Ranges
• Dynamic Chart Links

Alse see Dynamic Charts on the PTS Blog.

Worksheet Controls for Chart Interactivity

• Select a Chart Type with List Box or Drop Down Control
• Interactive Charting by Combo Box or Checkbox
• Interactive Parallel Coordinates Chart

VBA Chart Interactions

• Interactive Chart Creation
• Link Chart Axis Scale Parameters to Values in Cells
• Chart Events
  - Chart Events in Microsoft Excel
  - Get Information about a Plotted Point
  

Note for Excel 2007 users:

• Techniques using named ranges will fail if the names of the ranges begin with the word "Chart".
  Use names like ChtValues instead of ChartValues.