<div>
Fantastic - you saved my holiday break!
</div>


<div>
You may include a check for an actual formula<br />
<br />

<pre><code id="code-20-41652560-1">If Left$(p.DataLabel.Formula, 1) = &quot;=&quot; Then</code></pre>
<br />
since .Formula will return the data label's .Text if it isn't a &quot;real&quot; formula.
</div>


You may include a check for an actual formula



If Left$(p.DataLabel.Formula, 1) = "=" Then


since .Formula will return the data label's .Text if it isn't a "real" formula.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I used Rob Bovey's xy chart labeler to label a dataseries in a scatterplot. Each datalabel refers to a cell in the worksheet, such as &quot;=BE_Cat!$D$30&quot;, so the data label contains whatever is in cell d30, d31 etc.<br />
<br />
Unfortunately, I (or Excel) screwed up and have many, many files and charts where the label formula refers to the wrong sheet, e.g. &quot;=CV_Cat!$D$30&quot; instead of &quot;=BE_Cat!$D$30&quot;.<br />
<br />
To fix this, I'm looking for a macro to select a certain dataseries in a chart (Let's call it &quot;CV&quot;), and then circle through all the data labels in the series to change &quot;CV&quot; to &quot;BE&quot; in the label formula, i.e. from &nbsp;&quot;=CV_Cat!$D$30&quot; to &quot;=BE_Cat!$D$30&quot;, &quot;=CV_Cat!$D$31&quot; to &quot;=BE_Cat!$D$31&quot;, and so on.<br />
<br />
Thank you!!!!
</div>
</div>


Hello,

I used Rob Bovey's xy chart labeler to label a dataseries in a scatterplot. Each datalabel refers to a cell in the worksheet, such as "=BE_Cat!$D$30", so the data label contains whatever is in cell d30, d31 etc.

Unfortunately, I (or Excel) screwed up and have many, many files and charts where the label formula refers to the wrong sheet, e.g. "=CV_Cat!$D$30" instead of "=BE_Cat!$D$30".

To fix this, I'm looking for a macro to select a certain dataseries in a chart (Let's call it "CV"), and then circle through all the data labels in the series to change "CV" to "BE" in the label formula, i.e. from  "=CV_Cat!$D$30" to "=BE_Cat!$D$30", "=CV_Cat!$D$31" to "=BE_Cat!$D$31", and so on.

Thank you!!!!

VBA to change formula in data label

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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