+ Reply to Thread
Results 1 to 7 of 7

Open high low close chart with range increasing with column

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

    Open high low close chart with range increasing with column

    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!
    Attached Files Attached Files
    Last edited by rajre; 08-17-2014 at 11:23 PM.

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

    Re: Open high low close chart with range increasing with column

    instead of double click, a chart button also ok..example chart button is in f2 cell and i can enter c1 or d1 or e1 ..etc.... in e2 cell and get the chart
    Last edited by rajre; 08-16-2014 at 10:36 AM.

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Open high low close chart with range increasing with column

    the output is in Hoja1 (sheet 2) try double-clicking D ,E, of F columns
    Attached Files Attached Files

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

    Re: Open high low close chart with range increasing with column

    sir i need three bars only and each bar with its own open high low close values.

    example if i click c2 ..three bars should appear in chart
    first bar open high low close values B1=988.58,MAX(B1:B5)=988.84,MIN(B1:B5)=988.58,B5=988.77
    second bar open high low close values B6=988.74,MAX(B6:B10)=988.74,MIN(B6:B10)=988.62,B10=988.62
    third bar open high low close values B11=988.64,MAX(B11:B15)=988.66,MIN(B11:B15)=988.64,B15=988.65
    SORRY my bad iam confused range with time series
    Last edited by rajre; 08-16-2014 at 02:03 PM.

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

    Re: Open high low close chart with range increasing with column

    sir if you change y axis in to x axis and x axis to y axis, i will get exactly three bars with each open high low close values

  6. #6
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Open high low close chart with range increasing with column

    Hoping this is what you want
    Attached Files Attached Files

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

    Re: Open high low close chart with range increasing with column

    Thank you so much rcm, now i got what i want.

    Regards rajre

  8. #8
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Open high low close chart with range increasing with column

    OK just donīt forget to mark the thread as SOLVED

+ 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. elliminating series overlap on volume-open-high-low-close chart
    By luv2glyd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-27-2012, 03:36 AM
  2. Replies: 6
    Last Post: 06-04-2010, 11:55 AM
  3. Deriving close-high-low-open
    By db8r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2009, 09:53 AM
  4. [SOLVED] Excel should have an open/close high/low chart for stock market u.
    By Harold Hommes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2005, 01:06 PM
  5. [SOLVED] Stock High-Low-Close Chart
    By Tim in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-20-2005, 06:06 PM

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