Including a Cell value into a Chart title with the Text?
 

I've read through many of the items here looking for a solution to my
problem, but have had no luck yet. Here's what I'm trying to do:
I've created a Pie Chart and want the Title of the Pie Chart to read:

Percentages of =D136 Total Calls to Date

Of course D136 is the cell that has a formula that totals up column D. The
Pie Chart updates it's wedges fine with the changes to the data in Columns A
through C, but I want the Total to update in the Title of the Chart. I've
been successful in clicking on the Title, then hitting the = sign, and
clicking on cell D136 and hitting Enter, and it puts the total in there and
updates it, but that's all, no Text to explain what that number means.

Any help would be appreciated!
--
Thanks,
Bill

Answer: Including a Cell value into a Chart title with the Text?
 

Hi Bill,

To include the cell value into a chart title with text, you can use a combination of text and cell reference in the chart title formula. Here's how you can do it:

1. Click on the chart title to select it.
2. In the formula bar, type the following formula:
   
   Formula:

   ---

   ="Percentages of "&D136&" Total Calls to Date" 


   ---

3. Press Enter to apply the formula.

This formula concatenates the text "Percentages of" with the value in cell D136 and the text "Total Calls to Date" to create the chart title.

Now, whenever the value in cell D136 changes, the chart title will update automatically to reflect the new value.

Including a Cell value into a Chart title with the Text?
 

Build the entire title in a cell, then link the title to that cell.. In a
cell (say, E136) enter this formula:

="Percentages of "&D136&" Total Calls to Date"

Select the title, click in the formula bar, type =, then select cell E136.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bill" wrote in message
...
I've read through many of the items here looking for a solution to my
problem, but have had no luck yet. Here's what I'm trying to do:
I've created a Pie Chart and want the Title of the Pie Chart to read:

Percentages of =D136 Total Calls to Date

Of course D136 is the cell that has a formula that totals up column D.
The
Pie Chart updates it's wedges fine with the changes to the data in Columns
A
through C, but I want the Total to update in the Title of the Chart. I've
been successful in clicking on the Title, then hitting the = sign, and
clicking on cell D136 and hitting Enter, and it puts the total in there
and
updates it, but that's all, no Text to explain what that number means.

Any help would be appreciated!
--
Thanks,
Bill

Including a Cell value into a Chart title with the Text?
 

Jon, Thank You!!!! Exactly what I needed!
--
Thanks,
Bill


"Jon Peltier" wrote:

Build the entire title in a cell, then link the title to that cell.. In a
cell (say, E136) enter this formula:

="Percentages of "&D136&" Total Calls to Date"

Select the title, click in the formula bar, type =, then select cell E136.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bill" wrote in message
...
I've read through many of the items here looking for a solution to my
problem, but have had no luck yet. Here's what I'm trying to do:
I've created a Pie Chart and want the Title of the Pie Chart to read:

Percentages of =D136 Total Calls to Date

Of course D136 is the cell that has a formula that totals up column D.
The
Pie Chart updates it's wedges fine with the changes to the data in Columns
A
through C, but I want the Total to update in the Title of the Chart. I've
been successful in clicking on the Title, then hitting the = sign, and
clicking on cell D136 and hitting Enter, and it puts the total in there
and
updates it, but that's all, no Text to explain what that number means.

Any help would be appreciated!
--
Thanks,
Bill