anyone very adept with excel

katcha · **Posted:** Wed Jun 27, 2007 10:20 am

have a daily chart

and tabs across the bottom for each day

the data for the graphs to run with the chart is defaulted to sheet one on every page

is the anyway that i can put a variable in to ensure that it just uses the sheet for the day i am on rather than just defaulting to sheet 1 - otherwise it will mean 31 different data series for each individual day?

grabec · **Posted:** Wed Jun 27, 2007 10:45 am

Sounds like preparations are afoot for one of Cornelius' dodgier liaisions :uhoh:

katcha · **Posted:** Wed Jun 27, 2007 1:05 pm

MadJohn wrote:

Not entirely sure that I understand what you're trying to do.

Do you have just one chart and 31 different data sheets, and you want the chart to pick up data from the appropriate sheet based on a value you enter. For example, you have a cell (say, A1) where you enter a number, e.g. 16 and you would want the chart to pick up data from Sheet16.

Or am I miles out?

every day i update details of a few things in a data table from which the info is transferred to a graph.

however i want to just copy the graph and enter a variable to take the place of sheet1

in the following eg

=Sheet1!$G$8:$JS10

so that each sheet up to 31 takes care of itself
rather than me doing new graphs
however the time i have spent doing this
i coudl have done the 31 graphs!

Spender · **Posted:** Wed Jun 27, 2007 2:57 pm

ADG wrote:

I always had a thing for that Stephie Graph............ :uhoh:

Was it a big fat gut?? Do you still look like you're looking over a pile of crumpets?? :roll:

anyone very adept with excel

Gadgies online