VBA processes chart,SeriesCollection.Values errors when the data selection of the original chart exceeds the real data area.

excel has a chart, line chart.
assume that the data selection is Range ("B1:B10")
if cell B10 is empty,
reads Sheet1.ChartObjects (1) .Chart.SeriesCollection (1) .values Times error.

I guess the reason is the blank lines at the end of
, for example, B10 is empty and empty, but this line does not exist. Reading is wrong.
but why manual drawing can be selected, vba read error.

in addition

1. How to solve this problem?

2. How does vba get the selection range? of chart data

Mar.14,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b462-2bac9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b462-2bac9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?