Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamically change data in chart title
Is there a way to put a cell reference in the chart title text box? I have
numerous charts that have a date in the title. It would be much less work if I can modify a date in a cell and have all the charts automatically be updated. Example: "Service Calls - Sunday 02/03/08" would be "Service Calls - Sunday =A2" where cell A2 has my date. Or can this be modifiec via a VBA macro? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamically change data in chart title
Select the chart tile and then type the cell reference in the formula bar,
prefixed by the sheet name, such as =Sheet1!A2. To get what you want, in B2 add ="Service Calls - Sunday "&TEXT(A2,"dd-mmm-yyyy") and the reference that cell. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bill James" <Bill wrote in message ... Is there a way to put a cell reference in the chart title text box? I have numerous charts that have a date in the title. It would be much less work if I can modify a date in a cell and have all the charts automatically be updated. Example: "Service Calls - Sunday 02/03/08" would be "Service Calls - Sunday =A2" where cell A2 has my date. Or can this be modifiec via a VBA macro? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamically change data in chart title
Even easier, select the title, type = in the formula bar, then click on the
cell. This works with chart titles, axis titles, data labels, and shapes (text boxes etc). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Phillips" wrote in message ... Select the chart tile and then type the cell reference in the formula bar, prefixed by the sheet name, such as =Sheet1!A2. To get what you want, in B2 add ="Service Calls - Sunday "&TEXT(A2,"dd-mmm-yyyy") and the reference that cell. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bill James" <Bill wrote in message ... Is there a way to put a cell reference in the chart title text box? I have numerous charts that have a date in the title. It would be much less work if I can modify a date in a cell and have all the charts automatically be updated. Example: "Service Calls - Sunday 02/03/08" would be "Service Calls - Sunday =A2" where cell A2 has my date. Or can this be modifiec via a VBA macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i use a function to change chart title in Excel 2007 | Excel Worksheet Functions | |||
Possible to change chart title and label box widths? | Charts and Charting in Excel | |||
How to dynamically change the series range of a chart ? | Charts and Charting in Excel | |||
Excel: Can I change Chart-title/category/value from a sheet-cell? | Charts and Charting in Excel | |||
change chart title with auto filter | Charts and Charting in Excel |