+ Reply to Thread
Results 1 to 3 of 3

how to draw a single candlestick in excel

  1. #1
    Registered User
    Join Date
    11-24-2016
    Location
    india
    MS-Off Ver
    ms office10
    Posts
    50

    how to draw a single candlestick in excel

    sir,
    I have enclosed a sample data in excel sheet.
    I want to draw a single candle stick for the data in each of the row (open, High, Low Close)
    Additionally, it is preferred that the candle stick may be drawn on clicking the last cell adjacent to the data of each row f2 to f6 (cell colored green)
    thanks in advance
    vks1964
    Attached Files Attached Files
    Last edited by raja1964; 07-03-2019 at 01:53 PM.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: how to draw a single candlestick in excel

    Insert candlestick chart on your sheet, based on one of your series.

    Add this code to the worksheet module:
    Please Login or Register  to view this content.
    Example attached.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    177

    Re: how to draw a single candlestick in excel

    Hi,

    If you don't want VBA, and rather a formula, here it is:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The only "manual" input is the "36" that appears four times.

    Put the formula on F2, Cheers!
    John.

    "I excel at jumping to conclusions"

+ 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. Plotting Buy and Sell Data on Candlestick Chart in Excel
    By canikhil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-27-2018, 10:00 AM
  2. Adding Moving Average on Top of Candlestick chart on excel 2010
    By vb765 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-01-2013, 03:57 PM
  3. Candlestick charts and excel versions
    By billybigrigger in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-05-2012, 06:32 PM
  4. [SOLVED] Excel and Candlestick Chart?
    By Mike in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2006, 03:40 PM
  5. [SOLVED] Excel and Candlestick Graphs!?
    By Mike in forum Excel General
    Replies: 2
    Last Post: 08-07-2006, 03:05 PM
  6. Excel & Candlestick Graphs?
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2006, 03:05 PM
  7. How to draw the multiple chart in single sheet.
    By ramkumar_cpt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-10-2005, 12:07 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