Can I change the link to an Excel chart on the fly?

  • Thread starter Thread starter Padarick
  • Start date Start date
P

Padarick

Greetings,
I have a PP used for weekly meetings that needs to link to a few Excel
graphs created by other users. the problem is that each week they
create a new graph in their workbook and title the page with the
current week (01-08-Graph).

Is there a way to go after the current week's graph automatically??

Thanks
Patrick.
 
Padarick said:
Greetings,
I have a PP used for weekly meetings that needs to link to a few Excel
graphs created by other users. the problem is that each week they
create a new graph in their workbook and title the page with the
current week (01-08-Graph).

Is there a way to go after the current week's graph automatically??
Click to expand...

I can think of one or two ways to do this; it'll require a little User
Readjustment. First, a bit more info, please:

Is the chart always the same (only the data changes)?

Or is the chart liable to change as well as the data?
 
Back
Top