Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spiffy drop-down (with the box and arrow) that, when different
selections are chosen, modifies a chart to display different values. I cannot find a way to lock (and protect) the drop-down (so it can't be moved) and the chart (so that people - including myself - can't mess with the source data and such), but still be able to use the drop-down and watch the chart change to the new values. I know this is possible, as I have a worksheet that does it, but I can't for the life of me remember what I did. Thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A question about locking or protecting a worksheet | Excel Discussion (Misc queries) | |||
Question about Dynamic Charts | Charts and Charting in Excel | |||
excel charts, simple question | Excel Worksheet Functions | |||
Question on Excel Charts: | Excel Discussion (Misc queries) | |||
a question regarding dynamic ranges and charts | Charts and Charting in Excel |