scrollable candlestick not showing full data

in this i m trying to display the candlestick chart for data in range that's in table using scrollbar, it shows the data from data sheet only for about 14 days and stops plus the data from sheet data2 i m trying to display that as line on this existing candlestick chart but that just doesn't come & if i use change chart type n put it as secondary axis then the values open high low close change to custered columns instead of remain in candlestick

mktcandle.xlsx

HI
I found in this site (https://answers.microsoft.com/it-it/...0-f6e84f1a4f24) as follows:

Select open/high/low/close and create the stock chart as you already know how to do and then select it:

right click Select data,
Graph Data Range will display the range used so far. Press ; (semicolon) at the end and add the range containing the additional indicator
Complete chaos in the graph? Don't warry.

Still selecting the graph, from the Graph / Format Tools Menu:

in the drop-down list select this last series and then Selection format (under the drop-down list) in the Selection format you will have to indicate:
Series options: trace on secondary axis,
Line color: Solid line

Adapt everything to your needs

Hi,
Mario

PS: See also https://www.excelforum.com/excel-gen...ine-chart.html