scrollable candlestick not showing full data

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