Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
greg stenzel
 
Posts: n/a
Default Insert contents of a cell into a title of a chart

Is there a way???

  #2   Report Post  
greg stenzel
 
Posts: n/a
Default

On 2/20/05 5:14 PM, in article , "greg
stenzel" wrote:

Is there a way???

Also...I use a Mac and office 2004

  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

If the chart already has a title:
Click on the chart to select it
Select the chart title
Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.

If the chart doesn't have a title:
Click on the chart to select it
Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.
Drag the text box from the centre of the chart to the top
Use the buttons on the formatting toolbar to format the text



greg stenzel wrote:
Is there a way???



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
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
Relative Chart Title? Nick M Charts and Charting in Excel 6 June 22nd 05 09:24 PM
Insert new row as cell contents change George Excel Discussion (Misc queries) 2 January 26th 05 12:47 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
how to cell reference a Chart title Rasoul Khoshravan Azar Charts and Charting in Excel 2 January 1st 05 06:00 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"