+ Reply to Thread
Results 1 to 2 of 2

Creating a Weekly Candlestick chart

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Creating a Weekly Candlestick chart

    I have daily close data and am looking to create a weekly candlestick chart with this information. The Open would equal the first day of week's closing price, the close would be last day of the week. The High the Max for the week and the low the min of the week.
    The first tab is the chart and what I am trying get as an end result. Tab2 has the data added with the day,week and year numbers.

    Is there a way to look for example week 14 and return the first, max, min and last?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2007

    Re: Creating a Weekly Candlestick chart

    Hi I am not a doctor.

    Welcome to the forums.

    Attached is your chart: JET Settles.xlsx

    If you want to learn more about these charting and formula techniques, please check out these posts:

    Index and Match functions: Excel VLOOKUP-Left or Right and HLOOKUP Up or Down

    Case Study - Creating a Dynamic Chart in Excel Using Offset Formula

    Let me know if this helps.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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