Dynamic chart in Excel 2010?

[RobbieC]

Hi there, I have a column (A) with 40 potential inputs (time) and column B, readings of water depth at each time.

Is it possible to produce a dynamic graph based on these data sets in Excel 2010? Unfortunately, I'm stuck with the version.

What I'm aiming to do is have the y-axis scale to the time and the x-axis scale to width for the number of inputs (ie, the used range to the full width of the graph)

I think this is possible in later versions by using =offset(range), but if anyone has any good tips as to how I can produce these (or similar) in 2010, I'd be very grateful

Thanks

 

[GraH]

Hi,
You can make dynamic charts since early versions of Excel. 2010 will do just fine.

Chart_Depth formula : =Sheet1!$B$2:INDEX(Sheet1!$B$2:$B$41,COUNT(Sheet1!$B$2:$B$41))
Chart_Time formula : =Sheet1!$A$2:INDEX(Sheet1!$A$2:$A$41,COUNT(Sheet1!$A$2:$A$41))

You can find a dummy data generator as demo hereunder.

Book1
	A	B	C	D	E	F	G
1	Time Input	Water depth				Randomizer of range	13
2	0:30	0,115880328
3	1:00	0,120228923
4	1:30	0,862418606
5	2:00	0,429061777
6	2:30	0,759794183
7	3:00	0,697739827
8	3:30	0,995241247
9	4:00	0,685596682
10	4:30	0,433066736
11	5:00	0,481306124
12	5:30	0,723896902
13	6:00	0,339195694
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
Sheet1

Cell Formulas
Range	Formula
G1	G1	=RANDBETWEEN(1,40)+1
A2:A41	A2	=IF(ROW()<=$G$1,N(A1)+TIME(0,30,0),"")
B2:B41	B2	=IF(A2="","",RAND())

 

[RobbieC]

Thank you very much GraH, you are a star! Does exactly what I want it to do

Reagrda

Rob

 

[GraH]

Glad you like it, Rob, and that I could show a way you could follow. Appreciate the thumps up. Thank you.