L
Leanne
Hello
I have different exported information on sheets in a
workbook. For example Sheet a would have data for one day
and sheet b, the next day, etc. The data will be in the
same cell references on each sheet. Is there a way to plot
this data? I am looking for a formula that will plot all
the data for each sheet. I tried (sheeta e11, sheetb e11)
etc but it will not seem to let me do this. If i cannot
plot it directly in a graph, I would at least like to put
in into a column on the last sheet( the summary sheet). I
would like to somehow do this without manually entering
all the data (=sheeta e11) bla bla PS I have excel 97
Please let be know if someone knows how to do this and
please reply to my email
Thank you
I have different exported information on sheets in a
workbook. For example Sheet a would have data for one day
and sheet b, the next day, etc. The data will be in the
same cell references on each sheet. Is there a way to plot
this data? I am looking for a formula that will plot all
the data for each sheet. I tried (sheeta e11, sheetb e11)
etc but it will not seem to let me do this. If i cannot
plot it directly in a graph, I would at least like to put
in into a column on the last sheet( the summary sheet). I
would like to somehow do this without manually entering
all the data (=sheeta e11) bla bla PS I have excel 97
Please let be know if someone knows how to do this and
please reply to my email
Thank you