Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine Formula and static Text
Hi Group,
Using Excel 2003, in excel chart, I have changed the chart title to generate the name based on a cell text. But, all I want is to append text to the generated name. My sample formula for chart name looks like ='MySheet'!$B$1. But if I change to ='MySheet'!$B$1 & "Hello Text" and also, ='MySheet'!$B$1 & TEXT("Hello Text") does not seem to work. I am happy to find forum that will ease my job. Best Regards |
#2
|
|||
|
|||
It is not possible to concatenate a chart title referring to a cell and a
text string, you can use a macro that will do it or referring to a second cell where you use the contents of one cell (B1) and the string -- Regards, Peo Sjoblom (No private emails please) "Beginer" wrote in message ... Hi Group, Using Excel 2003, in excel chart, I have changed the chart title to generate the name based on a cell text. But, all I want is to append text to the generated name. My sample formula for chart name looks like ='MySheet'!$B$1. But if I change to ='MySheet'!$B$1 & "Hello Text" and also, ='MySheet'!$B$1 & TEXT("Hello Text") does not seem to work. I am happy to find forum that will ease my job. Best Regards |
#3
|
|||
|
|||
Hi Sjoblom,
Could you please provide me a sample work around ? Thanks in advance, Beginer "Peo Sjoblom" wrote: It is not possible to concatenate a chart title referring to a cell and a text string, you can use a macro that will do it or referring to a second cell where you use the contents of one cell (B1) and the string -- Regards, Peo Sjoblom (No private emails please) "Beginer" wrote in message ... Hi Group, Using Excel 2003, in excel chart, I have changed the chart title to generate the name based on a cell text. But, all I want is to append text to the generated name. My sample formula for chart name looks like ='MySheet'!$B$1. But if I change to ='MySheet'!$B$1 & "Hello Text" and also, ='MySheet'!$B$1 & TEXT("Hello Text") does not seem to work. I am happy to find forum that will ease my job. Best Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Explain return of #N/A | Excel Worksheet Functions | |||
Static cell reference | Excel Worksheet Functions | |||
Formula to identify what was NOT found | Excel Worksheet Functions | |||
Hyperlinks static but formulas are not. Why? | Excel Discussion (Misc queries) | |||
Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions |