Filename in Chart Series Values


I have a Defined Name for a calcualtion that works out the set of values I need for a series to use in a graph.

So… I need to use this defined name when entering series data for the chart. Part of this requires you to provide the filename of the worksheet you are using. (i.e. In the Series_Values box Excell 2010).

I would like to reference the filename to the contents of a cell so that I dont have to edit the series every time a filename changes. Even better I’d like to use an expression that will deliver the filename as part of the series value.

I’ve tried using CELL(“address”) but I get a ‘That Function is not valid” message. 

It seems that the Edit Series has to have the filename typed in and wont accept anything else.


I must be crazy!




Leave a Reply

Your email address will not be published. Required fields are marked *