Hi,I have time in column A and data in column B. i need three bars appear in chart with open high low close values like this...
If i double click c1,these 3 bars should appear in chart with ranges....A1:A5 ,A6:A10 ,A11:A15
If i double click d1,these 3 bars should appear in chart with ranges....A1:A6 ,A7:A12 ,A13:A18
If i double click e1,these 3 bars should appear in chart with ranges... A1:A7 ,A8:A14 ,A15:A21
and goes on across up to 200 columns.
and again
If i double click c2,these 3 bars should appear in chart with ranges.....A2:A6 ,A7:A11 ,A12:A16
If i double click d2,these 3 bars should appear in chart with ranges.....A2:A7 ,A8:A13 ,A14:A19
If i double click e2,these 3 bars should appear in chart with ranges.... A2:A8 ,A9:A15 ,A16:A22
and goes on across up to 200 columns.
and again
If i double click c3,these 3 bars should appear in chart with ranges.....A3:A7 ,A8:A12 ,A13:A17
If i double click d3,these 3 bars should appear in chart with ranges......A3:A8 ,A9:A14 ,A15:A20
If i double click e3,these 3 bars should appear in chart with ranges ... A3:A9 ,A10:A16 ,A17:A23
and goes on across up to 200 columns.
down to 20000 rows
with clicking horizontally across column one row range will get increased.
but with vertically same range.
i need to click only one chart at a time. with another click same chart should be changed to different values.
these three bars should appear with each ones open high low close values .attached sample data file. anybody help me writing a code for this!
Bookmarks