如何为phpspreadsheet图表获取正确的x轴格式？

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

$spreadsheet = new Spreadsheet();
$reader = new Xlsx();

$spreadsheet = $reader->load('path/to/your/excel/file.xlsx');
$worksheet = $spreadsheet->getActiveSheet();

$chart = $worksheet->getChartByIndex(0); // 获取第一个图表

$xAxisValues = [
    new \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues('String', 'Sheet1!$A$2:$A$6', null, 5), // 设置为字符串格式的x轴值
    new \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues('Number', 'Sheet1!$B$2:$B$6', null, 5), // 设置为数字格式的x轴值
];

$chart->getXAxis()->setValues($xAxisValues);

$xAxis = $chart->getXAxis();

$xAxis->setTickLabelSpacing(2); // 设置标签之间的间距
$xAxis->setTickLabelRotation(45); // 设置标签的旋转角度
$xAxis->getTitle()->setText('X轴标题'); // 设置x轴标题
$xAxis->getMajorGridlines()->setVisible(true); // 显示x轴的主要网格线
$xAxis->getMajorGridlines()->setDashType(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet::DASH_TYPE_SOLID); // 设置网格线的样式

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
$writer->save('path/to/save/excel/file.xlsx');