LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 390
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing Chart title with Text box Neil T Charts and Charting in Excel 2 June 13th 07 09:09 PM
axis title text box is wrong size in chart for excel 2003 hey_scott Charts and Charting in Excel 5 February 16th 06 12:25 AM
Chart title text linked from a cell? Possible? cwinters Excel Discussion (Misc queries) 2 October 10th 05 09:28 PM
Chart Title or Text Box Linked to cell & sheet Caliberx Charts and Charting in Excel 5 June 17th 05 04:59 PM
dynamic chart title text cwinters Excel Discussion (Misc queries) 2 June 9th 05 08:31 PM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"