Avatar of jjc9809
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?
Microsoft Excel

Avatar of undefined
Last Comment
Jon_Peltier

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
dlmille

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jon_Peltier

Dave didn't bother to tell you how to point the text elements to worksheet cells.

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/
Your help has saved me hundreds of hours of internet surfing.
fblack61