Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Automatic chart title

How do I make a chart format that will automatically use the name of series 1
as the title when creating the chart?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 201
Default Automatic chart title

You can format the chart title so it displays whatever is in a particular
cell. When going through the chart creation wizard, for title just type in
"title". Then when the chart is displayed, click into the chart title, and
then in the formula bar type "=" and then click on the cell with the series
name in it. This could be developed much further by writing a formula that is
more descriptive and pointing the title to that cell.

"hmm" wrote:

How do I make a chart format that will automatically use the name of series 1
as the title when creating the chart?

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
Automatic Title on each page Don Murphy, Brev. County Elections Excel Discussion (Misc queries) 1 June 21st 07 06:36 PM
Formula in Chart Title Phil Hageman Charts and Charting in Excel 9 April 10th 07 06:15 AM
Excel chart - how to assign the file name in the chart title? TGreen Charts and Charting in Excel 1 August 16th 05 10:35 AM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM
Chart Title LDanix Charts and Charting in Excel 2 January 17th 05 10:02 AM


All times are GMT +1. The time now is 12:56 AM.

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"