Excel Candlestick Chart Up Bars

Copper Contributor

I am using the stock history function to call stock data for the past 6 months and then create a candlestick chart. The problem is the chart doesn't have up bars only down bars. However, when I use another api to call the stock data, I get the up bars. I am wondering if the problem is the headers of the external api, adjusted close, and excel's stock history function, close. 

2 Replies
A screenshot of your data would help...

@JonPeltier

 

Hi Jon,

why my Candlestick Chart Bars look like this? It really doesn't look as Candlestick Bars. Please help. I am using Microsoft 365 Basic.

 

Boki_B_1-1705789338226.png