jjc9809
asked on
Another Bar Chart Question with EXCEL 2007
Hi Everyone!
I need to protect the sheet and keep users from clicking on formulas and such. I know how to protect the entire sheet, but what if I want to have the ability to make changes to a Bar Chart Title or other formatted text box titles? How do I unprotect the chart title, but leave the bar chart protected and other parts of the sheet with formulas and such. Can this bedone?
I need to protect the sheet and keep users from clicking on formulas and such. I know how to protect the entire sheet, but what if I want to have the ability to make changes to a Bar Chart Title or other formatted text box titles? How do I unprotect the chart title, but leave the bar chart protected and other parts of the sheet with formulas and such. Can this bedone?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
You do this by selecting the text element, clicking in the formula bar, typing an equals sign, then clicking on the cell with the deisred text. This puts a formula into the formula bar, something like =Sheet1!$A$1.
This works for the chart title, axis titles, data labels (labels on data points), and shapes containing text. For more details, see http://peltiertech.com/WordPress/link-chart-text-to-a-cell/