If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula in Chart Title
I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is
located in cell J1. What would the formula be? Thanks, Phil |
#2
|
|||
|
|||
In another cell, e.g. J2, enter the formula:
="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks, Debra. Works exactly as needed. Phil
"Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Debra,
I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
The Chart Title can contain a cell reference so, if you prefer, you can
add a title to the chart and link it to the cell with the formula. Phil Hageman wrote: Debra, I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
|
|||
|
|||
I moved the text box away from the title area, went to Chart Options/Chart
Title, and typed =K1. That's exactly what came up as a chart title - K1. Is there something else required to make a reference to a cell work for the Chart Title. The text box solution is working okay, so plan A is in place. I'm simply wondering about how to stay within a default mode in chart construction. I have to hand this chart to "average" users... "Debra Dalgleish" wrote: The Chart Title can contain a cell reference so, if you prefer, you can add a title to the chart and link it to the cell with the formula. Phil Hageman wrote: Debra, I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#7
|
|||
|
|||
The formula won't work correctly if you enter it in the Chart Options
dialog box. Add a title with any text, then close the Chart Options dialog box. Select the title on the chart Type an equal sign, then click on cell K1, and press Enter. Phil Hageman wrote: I moved the text box away from the title area, went to Chart Options/Chart Title, and typed =K1. That's exactly what came up as a chart title - K1. Is there something else required to make a reference to a cell work for the Chart Title. The text box solution is working okay, so plan A is in place. I'm simply wondering about how to stay within a default mode in chart construction. I have to hand this chart to "average" users... "Debra Dalgleish" wrote: The Chart Title can contain a cell reference so, if you prefer, you can add a title to the chart and link it to the cell with the formula. Phil Hageman wrote: Debra, I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#8
|
|||
|
|||
Formula in Chart Title
debra, phil...
perfect question, perfect anwser (should be in Excel Help!) thank you both. and you did it back in 2005! it's now 2007. some 25 yrs ago i persuaded my parents to buy microsoft (they'd never heard of it)... oh boy!!! thanks again, helen london "Debra Dalgleish" wrote: The formula won't work correctly if you enter it in the Chart Options dialog box. Add a title with any text, then close the Chart Options dialog box. Select the title on the chart Type an equal sign, then click on cell K1, and press Enter. Phil Hageman wrote: I moved the text box away from the title area, went to Chart Options/Chart Title, and typed =K1. That's exactly what came up as a chart title - K1. Is there something else required to make a reference to a cell work for the Chart Title. The text box solution is working okay, so plan A is in place. I'm simply wondering about how to stay within a default mode in chart construction. I have to hand this chart to "average" users... "Debra Dalgleish" wrote: The Chart Title can contain a cell reference so, if you prefer, you can add a title to the chart and link it to the cell with the formula. Phil Hageman wrote: Debra, I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#9
|
|||
|
|||
Formula in Chart Title
You're welcome! Thanks for checking the newsgroup archives to find the
answer that you needed. helen a wrote: debra, phil... perfect question, perfect anwser (should be in Excel Help!) thank you both. and you did it back in 2005! it's now 2007. some 25 yrs ago i persuaded my parents to buy microsoft (they'd never heard of it)... oh boy!!! thanks again, helen london "Debra Dalgleish" wrote: The formula won't work correctly if you enter it in the Chart Options dialog box. Add a title with any text, then close the Chart Options dialog box. Select the title on the chart Type an equal sign, then click on cell K1, and press Enter. Phil Hageman wrote: I moved the text box away from the title area, went to Chart Options/Chart Title, and typed =K1. That's exactly what came up as a chart title - K1. Is there something else required to make a reference to a cell work for the Chart Title. The text box solution is working okay, so plan A is in place. I'm simply wondering about how to stay within a default mode in chart construction. I have to hand this chart to "average" users... "Debra Dalgleish" wrote: The Chart Title can contain a cell reference so, if you prefer, you can add a title to the chart and link it to the cell with the formula. Phil Hageman wrote: Debra, I see in Chart Options the Chart Title now does not exist. Does this mean Chart Title cannot hold a formula, and to do so requires a text box? Will the text box function/act exactly the same as Chart Title? Phil "Debra Dalgleish" wrote: In another cell, e.g. J2, enter the formula: ="FORECAST THROUGH " & UPPER(TEXT(J1,"dd mmm yy")) Select the chart Type an equal sign, then click on the cell that contains the formula Press the Enter key Move and format the text box that contains the title text. Phil Hageman wrote: I want a chart title to say: FORCAST THROUGH 26 SEP 05. Where the date is located in cell J1. What would the formula be? Thanks, Phil -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart title = cell contects | Dkso | Charts and Charting | 4 | August 27th, 2005 01:57 PM |
Excel chart - how to assign the file name in the chart title? | TGreen | Charts and Charting | 1 | August 16th, 2005 10:35 AM |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
Chart Dynamic title | [email protected] | General Discussion | 5 | April 3rd, 2005 12:48 PM |
Convert Chart Series Formula to Array Via VBA? | Kevin G | Charts and Charting | 1 | May 5th, 2004 04:52 AM |