Excel 2007 - Controls in Charts?

[Tim Mayes]

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

 

[Jon Peltier]

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

 

[Tim Mayes]

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