graph title

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hans Hamers - 29 Nov 2005 18:39 GMT

Is there a way to use the current filename as "Chart Title" in the "Chart
Options" of a graph ?

Reply to this Message

Andy Pope - 29 Nov 2005 22:20 GMT

Hi,

You can link the chart title to a cell. See here for instructions.
http://www.andypope.info/tips/tip001.htm

And the cell to which you link can contain this formula, which will
extract the filename from the returned string. I have split the formula
over 3 lines in case wrapping within the email screws with the formula.

=MID(CELL("Filename",A1),
FIND("[",CELL("filename",A1))+1,FIND("]",
CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

Cheers
Andy

> Is there a way to use the current filename as "Chart Title" in the "Chart
> Options" of a graph ?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Bernard Liengme - 29 Nov 2005 22:28 GMT

In some convenient cell enter =MID(LEFT(CELL("filename",A1),
FIND(".",CELL("filename",A1))-1),FIND("[",CELL("filename",A1))+1, 255)
This gets the file name into a cell
Make the chart and add a tile (anything will do)
Click on the tile in the chart, in the formula bar type = and then point to
the cell with the formula given above.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Is there a way to use the current filename as "Chart Title" in the "Chart
> Options" of a graph ?

Reply to this Message