Creating a Weekly Candlestick chart

[IamNotaDoctor]

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?

[Steve=True]

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.

Thanks

Steve=True