Excel 2007 - Controls in Charts?
 

One of the features that I have often used in previous versions of Excel is
having a control (e.g., a spin button) in a chart. Obviously, the control would
be linked to the spreadsheet from which the chart gets its data. I cannot get
this to work in Excel 2007. I am using the B2TR. When I try to put the control
on the chart, I get a status bar message that says to click and drag, but
nothing happens.

Have they eliminated this functionality? I really hope not, since this is very
valuable for presentations in my finance classes.

Thanks

Excel 2007 - Controls in Charts?
 

Tim -

I didn't test this very thoroughly. I do know there were issues with the use
of controls on charts, but I don't know the extent of these problems or what
their status is.

Are you using controls on a chart sheet, or in an embedded chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tim Mayes" wrote in message
...
One of the features that I have often used in previous versions of Excel
is having a control (e.g., a spin button) in a chart. Obviously, the
control would be linked to the spreadsheet from which the chart gets its
data. I cannot get this to work in Excel 2007. I am using the B2TR. When I
try to put the control on the chart, I get a status bar message that says
to click and drag, but nothing happens.

Have they eliminated this functionality? I really hope not, since this is
very valuable for presentations in my finance classes.

Thanks

Excel 2007 - Controls in Charts?
 

Jon,

I've always used the controls on a chart sheet. Obviously, that gives me a
full-screen chart, and I don't have to return to the worksheet to change the values.

I really hope that they are working on getting this fixed.

Thanks,

Tim

Jon Peltier wrote:
Tim -

I didn't test this very thoroughly. I do know there were issues with the use
of controls on charts, but I don't know the extent of these problems or what
their status is.

Are you using controls on a chart sheet, or in an embedded chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com