爱刨根知识网

  1. 首页 > 经验知识 > >

怎么设置图表坐标轴格式,xlsx中怎么设置图表坐标轴格式

生活经验怎么

默认情况下 ， 创建图表时 ， Excel会自动设置其坐标轴属性 。这些属性包括坐标轴选项 ， 例如边界最大值 ， 边界最小值 ， 主要单位 ， 次要单位；刻度线标记的主要类型 ， 次要类型；标签位置；横坐标轴交叉设置；是否逆序刻度值等 。但是有时我们需要手动设置这些属性来完善和美化图表 。本文将介绍如何使用Spire.XLS自定义设置Excel图表坐标轴格式 。
代码段：
//创建Workbook对象 ， 获取第一个工作表Workbook workbook = new Workbook();workbook.CreateEmptySheets(1);Worksheet sheet = workbook.Worksheets[0];//添加示例数据sheet.Name = "Demo";sheet.Range["A1"].Value = "http://www.baifabohui.com/smjk/Month";sheet.Range["A2"].Value = "http://www.baifabohui.com/smjk/Jan";sheet.Range["A3"].Value = "http://www.baifabohui.com/smjk/Feb";sheet.Range["A4"].Value = "http://www.baifabohui.com/smjk/Mar";sheet.Range["A5"].Value = "http://www.baifabohui.com/smjk/Apr";sheet.Range["A6"].Value = "http://www.baifabohui.com/smjk/May";sheet.Range["A7"].Value = "http://www.baifabohui.com/smjk/Jun";sheet.Range["A8"].Value = "http://www.baifabohui.com/smjk/Jul";sheet.Range["A9"].Value = "http://www.baifabohui.com/smjk/Aug";sheet.Range["B1"].Value = "http://www.baifabohui.com/smjk/Planned";sheet.Range["B2"].NumberValue = http://www.baifabohui.com/smjk/38;sheet.Range["B3"].NumberValue = http://www.baifabohui.com/smjk/47;sheet.Range["B4"].NumberValue = http://www.baifabohui.com/smjk/39;sheet.Range["B5"].NumberValue = http://www.baifabohui.com/smjk/36;sheet.Range["B6"].NumberValue = http://www.baifabohui.com/smjk/27;sheet.Range["B7"].NumberValue = http://www.baifabohui.com/smjk/25;sheet.Range["B8"].NumberValue = http://www.baifabohui.com/smjk/36;sheet.Range["B9"].NumberValue = http://www.baifabohui.com/smjk/48;//根据示例数据创建柱形图Chart chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);chart.DataRange = sheet.Range["B1:B9"];chart.SeriesDataFromRange = false;chart.PlotArea.Visible = false;chart.TopRow = 6;chart.BottomRow = 25;chart.LeftColumn = 2;chart.RightColumn = 9;chart.ChartTitle = "Chart with Customized Axis";chart.ChartTitleArea.IsBold = true;chart.ChartTitleArea.Size = 12;Spire.Xls.Charts.ChartSerie cs1 = chart.Series[0];cs1.CategoryLabels = sheet.Range["A2:A9"];//自定义设置图表坐标轴属性chart.PrimaryValueAxis.MajorUnit = 8;chart.PrimaryValueAxis.MinorUnit = 2;chart.PrimaryValueAxis.MaxValue = http://www.baifabohui.com/smjk/50;chart.PrimaryValueAxis.MinValue = 0;chart.PrimaryValueAxis.IsReverseOrder = false;chart.PrimaryValueAxis.MajorTickMark = TickMarkType.TickMarkOutside;chart.PrimaryValueAxis.MinorTickMark = TickMarkType.TickMarkInside;chart.PrimaryValueAxis.TickLabelPosition = TickLabelPositionType.TickLabelPositionNextToAxis;chart.PrimaryValueAxis.CrossesAt = 0;//保存文档workbook.SaveToFile("Result.xlsx", ExcelVersion.Version2010);效果图：

怎么设置图表坐标轴格式,xlsx中怎么设置图表坐标轴格式

文章插图
点击“了解更多”下载产品最新试用版
【怎么设置图表坐标轴格式,xlsx中怎么设置图表坐标轴格式】↓↓↓

    推荐阅读


    上一篇：苹果手机应该怎样才能解压，怎么在苹果手机里解压压缩包文件呢

    下一篇：整数除以分数怎么算，整数除以分数怎么计算