<div>
Dave didn't bother to tell you how to point the text elements to worksheet cells. <br />
<br />
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.<br />
<br />
This works for the chart title, axis titles, data labels (labels on data points), and shapes containing text. For more details, see <a href="http://peltiertech.com/WordPress/link-chart-text-to-a-cell/" rel="ugc">http://peltiertech.com/WordPress/link-chart-text-to-a-cell/</a>
</div>


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/ [http://peltiertech.com/WordPress/link-chart-text-to-a-cell/]

<div>
<div class="content wysiwyg-content">
Hi Everyone!<br />
<br />
I need to protect the sheet and keep users from clicking on formulas and such. &nbsp;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? &nbsp;How do I unprotect the chart title, but leave the bar chart protected and other parts of the sheet with formulas and such. &nbsp;Can this bedone?
</div>
</div>


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?

Another Bar Chart Question with EXCEL 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.