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