I have a chart (ChartSheet1)which populates based on a drop down box.
The drop down box sends a variable to Sheet2. Chartsheet1 range feeds
from Sheet2 based on this variable.

How do I use a WorkSheet_Change event to track the change in the
variable in Sheet2 so that I can modify the formats and title of my
chart?

RK