+ Reply to Thread
Results 1 to 2 of 2

Display all TRUE cell charts

  1. #1
    Registered User
    Join Date
    07-04-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    43

    Display all TRUE cell charts

    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!
    Attached Files Attached Files
    Last edited by rajre; 08-26-2015 at 12:17 AM.

  2. #2
    Registered User
    Join Date
    07-04-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    43

    Re: Display all TRUE cell charts

    anybody let me know ..is displaying multiple charts from data with single button press possible in excel?
    if not, display "next true value cell chart" button possible? i mean one by one?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 09-25-2013, 01:51 PM
  2. [SOLVED] Test for blank cell should be "True" but "False" action is taken.
    By Aceso in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-09-2013, 05:47 PM
  3. compare two excel sheets using macros and display the result in "true" or "false"
    By gayunana01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 07:21 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  6. If "text" exist within "cell" then TRUE
    By JemyM in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 09-16-2005, 07:41 PM
  7. IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 AM
  8. [SOLVED] set "value if true" to "fill cell with color"
    By Feeta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2005, 04:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1