| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Fixed Chart Location
How can I place a chart on a worksheet so that it cannot be moved around?
Thanks in advance for any help. -- Dave_DD |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Fixed Chart Location
You can protect it against user selection:
http://peltiertech.com/Excel/ChartsH...rotection.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave_AD" wrote in message ... How can I place a chart on a worksheet so that it cannot be moved around? Thanks in advance for any help. -- Dave_DD |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Fixed Chart Location
Jon,
Thanks for the help. It was simply a case of unprotecting the cells I want the user to change, but keeping the chart locked, then turning the sheet protection on. That way the chart can't be select and moved. -- Dave_DD "Jon Peltier" wrote: You can protect it against user selection: http://peltiertech.com/Excel/ChartsH...rotection.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave_AD" wrote in message ... How can I place a chart on a worksheet so that it cannot be moved around? Thanks in advance for any help. -- Dave_DD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for fixed color lines in line chart based on series name | Charts and Charting in Excel | |||
| how can I limit my chart | Charts and Charting in Excel | |||
| Location of pivot chart | Charts and Charting in Excel | |||
| How to move location of chart within a worksheet? | Excel Discussion (Misc queries) | |||
| Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Linear Mode
