How to insert Trend Lines in stock chart type 2?

I was trying to make a chart analysis of a stock with it’s date, open, high, low and close value and i was able to make a dynamic chart using pivot table but i cannot add trend lines in the stock chart type 2? Trend line is greyed out even when i clicked the data series. I tried with line chart type point and line and i was able to insert trend line in that. So how can i insert it in stock chart type 2.Chart.xlsx

Maybe you can overlay two charts. See answers at:


Add Answer is reserved for solutions. Please, click edit below your question if you want to add more information.