| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I insert the file name into a chart (without typing it)?
Hi,
You could use an embedded textbox linked to a cell. With the cell containing the formula, =MID(LEFT(CELL("Filename",A1),FIND("]",CELL("Filename",A1))-1), FIND("[",CELL("Filename",A1))+1, 255) the workbook needs to have been saved for this to work. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Navy Guy" wrote in message ... -- Excel Junkie always looking for formula ideas to more easily crunch data |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Insert Typing field has disappeared | Excel Discussion (Misc queries) | |||
| Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
| typing inside a pasted chart (jpg)?? | Excel Discussion (Misc queries) | |||
| insert file name | Excel Discussion (Misc queries) | |||
| insert data into chart | Charts and Charting in Excel | |||
Threaded Mode
