Chart does not show all dates that is in my data, some are missing from chart

[hendrikbez]

Not sure if this is in the correct forum

Need so new thinking on help with my problem.

In my sheet I have in column A24:D24 data that is pulled in from the internet
I then run it to show a candle chart, but my chart is not showing all the date that is from A24

I cannot figure out why it does this.

1. press chart button to get data and chart

[BadlySpelledBuoy]

All the data points are showing, but Excel can only display so many of the dates on screen without them overlapping, so it hides some to make it look nicer.
If you extend the width of the chart over to column AZ you'll see all the dates are there. Also shrinking the font size on the date axis you'll be able to see them all (but probably won't be able to read them).

BSB

[hendrikbez]

Thank you, for the information, noted

[BadlySpelledBuoy]

Happy to help

BSB