You don't need VBA change chart data or titles with a worksheet control.
Use controls from the Forms toolbar, and use the cell link value as a
parameter in a dynamic range definition. Then use this dynamic range in
the chart source data or in the cell that the chart or axis title is
linked to. Here is a page with hints about this:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

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