Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Is there a way to insert a date code/command in the Chart Title?
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Hi,
In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Thank's sooo very much! I'm going to try that right now!
Gwynne "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Shane, I did exactly what your answer said and it worked great! However, the
Date is now the entire title of my chart what is not exactly what I need. I need the title "WIA Disbursement and and Budget Summary - June 17, 2009". Can you help with this? Thanks# "Gwynne" wrote: Thank's sooo very much! I'm going to try that right now! Gwynne "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Just combine the text with the formula Shane provided.
A1:="WIA Disbursement and and Budget Summary - " & TEXT(TODAY(),"MMMM D, YYYY") Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Gwynne" wrote in message ... Shane, I did exactly what your answer said and it worked great! However, the Date is now the entire title of my chart what is not exactly what I need. I need the title "WIA Disbursement and and Budget Summary - June 17, 2009". Can you help with this? Thanks# "Gwynne" wrote: Thank's sooo very much! I'm going to try that right now! Gwynne "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Hi,
I felt so lucky that someone had answers for exactly what I want to do. But, I still have some issues in following your steps. I entered the date in cell A1. Then, I clicked the border of the Chart Title. But, where should I type "=A1"? I typed "A1" into the function box (Fx) but an error message occur. "The formula you typed contains an eorr. Try one of the following: -Make sure you've included all parentheses and requred arguments -To get assistance iwth using a function, click Function (Insert Menu) .... .... Did I type the "=A1" in wrong place? "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
Hi,
You did not include the sheet reference. http://www.andypope.info/tips/tip001.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Maple" wrote in message ... Hi, I felt so lucky that someone had answers for exactly what I want to do. But, I still have some issues in following your steps. I entered the date in cell A1. Then, I clicked the border of the Chart Title. But, where should I type "=A1"? I typed "A1" into the function box (Fx) but an error message occur. "The formula you typed contains an eorr. Try one of the following: -Make sure you've included all parentheses and requred arguments -To get assistance iwth using a function, click Function (Insert Menu) ... ... Did I type the "=A1" in wrong place? "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Current date (i.e., today()) in Chart Title
GOT IT!!!
Thanks!! "Andy Pope" wrote: Hi, You did not include the sheet reference. http://www.andypope.info/tips/tip001.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Maple" wrote in message ... Hi, I felt so lucky that someone had answers for exactly what I want to do. But, I still have some issues in following your steps. I entered the date in cell A1. Then, I clicked the border of the Chart Title. But, where should I type "=A1"? I typed "A1" into the function box (Fx) but an error message occur. "The formula you typed contains an eorr. Try one of the following: -Make sure you've included all parentheses and requred arguments -To get assistance iwth using a function, click Function (Insert Menu) ... ... Did I type the "=A1" in wrong place? "Shane Devenshire" wrote: Hi, In a cell, say A1, in the spreadsheet enter a formula like this: =TEXT(TODAY(),"M/D/YY") Now select the border of the chart title, not inside, and type =A1 when you press enter the title will use the value in cell A1 for your title. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Gwynne" wrote: Is there a way to insert a date code/command in the Chart Title? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display current date on chart | Excel Discussion (Misc queries) | |||
1st of current quater today() | Excel Discussion (Misc queries) | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
how do I get a current time using =TODAY() instead of 12:00 AM | Excel Discussion (Misc queries) | |||
Date in a chart title | Charts and Charting in Excel |