| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Mix Titles with Cell Links and Text
I would like to make a chart title have a mix of letters and a cell reference
formula similar to what I do in other cells. For example: ="text" & (left(A1,4)) I would hope this is possible but it keeps giving me an error. I have used just the ="text" & A1 and it works but when I add the formula, it says no. Any ideas? Jeff |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Mix Titles with Cell Links and Text
What about calculating the forumla in a different cell, and then
referencing that cell in the title? Jeff G wrote: I would like to make a chart title have a mix of letters and a cell reference formula similar to what I do in other cells. For example: ="text" & (left(A1,4)) I would hope this is possible but it keeps giving me an error. I have used just the ="text" & A1 and it works but when I add the formula, it says no. Any ideas? Jeff |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Mix Titles with Cell Links and Text
That's always an option but my spreadsheet already has 7 sheets and uses all
columns in the main sheet where the charts are located. I was just trying to combine my efforts for simplicity sake. "Matthew Cavagnaro" wrote: What about calculating the forumla in a different cell, and then referencing that cell in the title? Jeff G wrote: I would like to make a chart title have a mix of letters and a cell reference formula similar to what I do in other cells. For example: ="text" & (left(A1,4)) I would hope this is possible but it keeps giving me an error. I have used just the ="text" & A1 and it works but when I add the formula, it says no. Any ideas? Jeff |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Mix Titles with Cell Links and Text
It's not an option, it's the only way.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Jeff G" wrote in message ... That's always an option but my spreadsheet already has 7 sheets and uses all columns in the main sheet where the charts are located. I was just trying to combine my efforts for simplicity sake. "Matthew Cavagnaro" wrote: What about calculating the forumla in a different cell, and then referencing that cell in the title? Jeff G wrote: I would like to make a chart title have a mix of letters and a cell reference formula similar to what I do in other cells. For example: ="text" & (left(A1,4)) I would hope this is possible but it keeps giving me an error. I have used just the ="text" & A1 and it works but when I add the formula, it says no. Any ideas? Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't see all the text in a cell when using file links | Excel Worksheet Functions | |||
| linking a cell containing text to another cell containing text / data | Excel Discussion (Misc queries) | |||
| How to execute Macros through Text Links? | Excel Discussion (Misc queries) | |||
| 'CHECK IF A CELL IN EXCEL HAS ANY TEXT IN IT' | Excel Worksheet Functions | |||
| External links contain too much text | Excel Discussion (Misc queries) | |||
Hybrid Mode
