在C#中设置Excel散点图的x轴和y轴

using Excel = Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Excel.Application excelApp = new Excel.Application();

// 打开一个Excel工作簿
Excel.Workbook workbook = excelApp.Workbooks.Open("路径\\文件名.xlsx");

// 获取或创建一个工作表对象
Excel.Worksheet worksheet;
if (workbook.Worksheets.Count > 0)
{
    worksheet = workbook.Worksheets[1];
}
else
{
    worksheet = workbook.Worksheets.Add();
}

// 选择要操作的工作表
worksheet.Activate();

// 创建一个散点图对象
Excel.ChartObjects chartObjects = (Excel.ChartObjects)worksheet.ChartObjects(Type.Missing);
Excel.ChartObject chartObject = chartObjects.Add(10, 10, 400, 300);
Excel.Chart chart = chartObject.Chart;

// 设置数据源范围
Excel.Range dataRange = worksheet.Range["A1:B10"];
chart.SetSourceData(dataRange);

// 设置x轴的数据范围和标题
Excel.Axis xAxis = (Excel.Axis)chart.Axes(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary);
Excel.Range xDataRange = worksheet.Range["A2:A10"];
xAxis.CategoryNames = xDataRange;
xAxis.HasTitle = true;
xAxis.AxisTitle.Text = "X轴标题";

// 设置y轴的数据范围和标题
Excel.Axis yAxis = (Excel.Axis)chart.Axes(Excel.XlAxisType.xlValue, Excel.XlAxisGroup.xlPrimary);
Excel.Range yDataRange = worksheet.Range["B2:B10"];
yAxis.HasTitle = true;
yAxis.AxisTitle.Text = "Y轴标题";

// 设置散点图的标题
chart.HasTitle = true;
chart.ChartTitle.Text = "散点图标题";

// 设置散点图的图例
chart.HasLegend = true;
chart.Legend.Position = Excel.XlLegendPosition.xlLegendPositionRight;

// 保存Excel工作簿
workbook.Save();

// 关闭Excel工作簿
workbook.Close();

// 释放相关资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);