I got this "Chart with double click" macro workbook from this same forum(by rcm)..which displays three bars chart when i double click any "TRUE" value cell.
what i am doing every time with this workbook is ..step by step
1, enable macro workbook ,workbook is in manual calculation mode.
2, paste new data to A and B columns.
3, (formula is in F5 cell) select F5 cell,press "copypaste to range" button in attached workbook..it will paste formula across range.
4, press calculate
5, search all TRUE value cells with "FIND VALUE" function tab.
6, now go to first TRUE cell , press calculatation and double click ...now i got 3 bars chart with each open high low close in "grafico1" page.
after analysing chart..select another TRUE cell,press calculation and double click ,get the new chart replaces previous chart in same place in "grafico1" page ..and repeat the same to analyse all charts.
(iam analysing bullish bearish "pinbar trading pattern" where middle bar body size is very less than to its wicks or tail.
with some data shows only few charts ... with another set of data more than hundred charts appears)
what i need now, instead of everytime selecting TRUE cell and doubleclick.. i need a macro button near "copypate to range" button to get the all "TRUE cell" charts in single page.
I mean after above 4th step i will press this macro button to get the all charts in single page.
one by one chart vertically in another sheet.(with same size and parameters like in grafico1 page)
and also write name of the origin cell beside every displayed chart.
If displaying all charts not possible ..upto 100 charts enough for me.
create"clear all charts" button .so that i can test with another set of data.
Example data In attached workbook shows more than 80 TRUE value cells,
select F5 cell.. press copypate button, calculate and go to FIND VALUE tab enter "TRUE" and press search all, will get all TRUE value cells.(set worksheet in manual calculation mode).
i need all those TRUE value cell charts in single button press.
anybody help me!
Bookmarks