Passing Parameters to a Label

[Angelique]

Dear Folks,

I have several spreadsheets that have numerous graphs and each month I update the worksheets that feed these graphs. Now while the results display, the labels have to be manually changed, one by one and it takes hours.

Is there a way to pass a parameter to a label/title on the graph to update? If it is possible, can some provide the syntax.

The info to be changed is: 01/07/02 to 31/07/02 to 01/08/02 to 31/08/02 etc to the end of each financial year.

Yours



Angie

 

[rmikesmith]

Hi Angie,

I don't believe there is a way to directly link the title to a worksheet cell and have it update automatically. This is going to require some VBA code. If you can send a demo workbook (no insider financial data please ) showing the current data layout and chart you use, I'll take a look.

Email me at rmikesmith@earthlink.net

Regards,
Mike