This article explains how to display numeric axis labels in integer after zooming in Blazor Charts. Displaying axis labels in integer after zooming Blazor Charts provides an option to display the numeric axis labels only in integer after performing zooming in chart using OnAxisActualRangeCalculated event. This can be achieved by rounding the Interval value of numeric axis on OnAxisActualRangeCalculated event by checking the argument axis name is equal to PrimaryYAxis. This will render intervals in integer even after zooming the chart. The below code example demonstrates how to display numeric axis labels in integer. Index.razor @using Syncfusion.Blazor.Charts <SfChart> <ChartEvents OnAxisActualRangeCalculated="RangeCalculated"></ChartEvents> <ChartPrimaryXAxis ValueType="Syncfusion.Blazor.Charts.ValueType.Category"></ChartPrimaryXAxis> <ChartSeriesCollection> <ChartSeries DataSource="@Sales" XName="Month" YName="SalesValue" Type="Syncfusion.Blazor.Charts.ChartSeriesType.Column"> </ChartSeries> </ChartSeriesCollection> <ChartZoomSettings EnableSelectionZooming="true"></ChartZoomSettings> </SfChart> @code { public void RangeCalculated(AxisRangeCalculatedEventArgs Args) { if (Args.AxisName == "PrimaryYAxis") { Args.Interval = Math.Round(Args.Interval); } } public class SalesInfo { public string Month { get; set;} public double SalesValue { get; set;} } public List<SalesInfo> Sales = new List<SalesInfo> { new SalesInfo { Month = "Jan", SalesValue = 35 }, new SalesInfo { Month = "Feb", SalesValue = 28 }, new SalesInfo { Month = "Mar", SalesValue = 34 }, new SalesInfo { Month = "Apr", SalesValue = 32 }, new SalesInfo { Month = "May", SalesValue = 40 }, new SalesInfo { Month = "Jun", SalesValue = 32 }, new SalesInfo { Month = "Jul", SalesValue = 35 } }; } Output Live Sample for Displaying Integer Conclusion I hope you enjoyed learning how to display axis labels in integer after zooming in Blazor Chart Component. You can refer to our Blazor Chart feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our Blazor Chart example to understand how to create and manipulate data. For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls. If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, support portal, or feedback portal. We are always happy to assist you!
This article explains how to dynamically change the x-axis interval type in Blazor Charts. Dynamically Change the X-Axis Interval Type Blazor Charts provides an option to dynamically change the x-axis interval type. This can be achieved by using the OnZoomEnd event. This event allows you to modify the x-axis IntervalType, based on conditions that check the ZoomFactor and the IsDay boolean. The below code example demonstrates how to dynamically change the x-axis interval type Index.razor @using Syncfusion.Blazor.Charts <SfChart> <ChartPrimaryXAxis LabelFormat="@LabelFormat" Interval="2" IntervalType="@Type" ValueType="Syncfusion.Blazor.Charts.ValueType.DateTime"> </ChartPrimaryXAxis> <ChartEvents OnZoomEnd="OnZoomingEvent"></ChartEvents> <ChartPrimaryYAxis Minimum="0" Maximum="25000" Interval="5000" ValueType="Syncfusion.Blazor.Charts.ValueType.Double"> </ChartPrimaryYAxis> <ChartZoomSettings EnableMouseWheelZooming="true" EnablePinchZooming="true" EnableSelectionZooming="true"></ChartZoomSettings> <ChartSeriesCollection> <ChartSeries DataSource="@DataSource" XName="XValue" YName="YValue" Type="Syncfusion.Blazor.Charts.ChartSeriesType.Column"> </ChartSeries> </ChartSeriesCollection> </SfChart> @code { public class ChartData { public DateTime XValue { get; set; } public double YValue { get; set; } } public string LabelFormat { get; set; } = "yyyy-MM"; public IntervalType Type { get; set; } = IntervalType.Months; public bool IsDay { get; set; } = true; public List<ChartData> DataSource = new List<ChartData> { new ChartData { XValue = new DateTime(2023, 01, 01), YValue = 15243 }, new ChartData { XValue = new DateTime(2023, 02, 16), YValue = 24324 }, new ChartData { XValue = new DateTime(2023, 03, 23), YValue = 3422 }, new ChartData { XValue = new DateTime(2023, 04, 14), YValue = 5232 }, new ChartData { XValue = new DateTime(2023, 05, 06), YValue = 12535 }, new ChartData { XValue = new DateTime(2023, 06, 26), YValue = 22343 }, new ChartData { XValue = new DateTime(2023, 07, 30), YValue = 19082 }, new ChartData { XValue = new DateTime(2023, 08, 21), YValue = 12343 }, new ChartData { XValue = new DateTime(2023, 09, 15), YValue = 7002 }, new ChartData { XValue = new DateTime(2023, 10, 19), YValue = 8023 }, new ChartData { XValue = new DateTime(2023, 11, 21), YValue = 15643 }, new ChartData { XValue = new DateTime(2023, 12, 12), YValue = 3123 }, }; public void OnZoomingEvent(Syncfusion.Blazor.Charts.ZoomingEventArgs args) { if (args.AxisCollection[0].ZoomFactor < 0.7 && IsDay) { Type = IntervalType.Days; IsDay = false; LabelFormat = "dd-MM-yyyy"; DataSource = new List<ChartData> { new ChartData { XValue = new DateTime(2023, 04, 01), YValue = 15243 }, new ChartData { XValue = new DateTime(2023, 04, 16), YValue = 24324 }, new ChartData { XValue = new DateTime(2023, 04, 23), YValue = 3422 }, new ChartData { XValue = new DateTime(2023, 04, 14), YValue = 5232 }, new ChartData { XValue = new DateTime(2023, 04, 06), YValue = 12535 }, new ChartData { XValue = new DateTime(2023, 04, 26), YValue = 12323 }, new ChartData { XValue = new DateTime(2023, 04, 03), YValue = 14325 }, new ChartData { XValue = new DateTime(2023, 04, 12), YValue = 24213 }, new ChartData { XValue = new DateTime(2023, 04, 23), YValue = 24343 }, new ChartData { XValue = new DateTime(2023, 04, 30), YValue = 19082 }, }; StateHasChanged(); } else if (!IsDay) { Type = IntervalType.Months; IsDay = true; LabelFormat = "yyyy-MM"; DataSource = new List<ChartData> { new ChartData { XValue = new DateTime(2023, 01, 01), YValue = 15243 }, new ChartData { XValue = new DateTime(2023, 02, 16), YValue = 24324 }, new ChartData { XValue = new DateTime(2023, 03, 23), YValue = 3422 }, new ChartData { XValue = new DateTime(2023, 04, 14), YValue = 5232 }, new ChartData { XValue = new DateTime(2023, 05, 06), YValue = 12535 }, new ChartData { XValue = new DateTime(2023, 06, 26), YValue = 22343 }, new ChartData { XValue = new DateTime(2023, 07, 30), YValue = 19082 }, new ChartData { XValue = new DateTime(2023, 08, 21), YValue = 12343 }, new ChartData { XValue = new DateTime(2023, 09, 15), YValue = 7002 }, new ChartData { XValue = new DateTime(2023, 10, 19), YValue = 8023 }, new ChartData { XValue = new DateTime(2023, 11, 21), YValue = 15643 }, new ChartData { XValue = new DateTime(2023, 12, 12), YValue = 3123 }, }; StateHasChanged(); } } } The following screenshot illustrates the output of the code snippet. Live sample for dynamically change the x-axis interval type Conclusion I hope you enjoyed learning how to dynamically change the x-axis interval type in Blazor Charts. You can refer to our Blazor Chart feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our Blazor Chart example to understand how to create and manipulate data. For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls. If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, support portal, or feedback portal. We are always happy to assist you!
Syncfusion .NET MAUI Linear Gauge (SfLinaearGauge) supports customizing the interval between the scale labels. Follow the demonstration in this article to customize the interval between the scale labels. XAML: The Interval property of the SfLinearGauge is used to customize the interval between labels. The major ticks are created depending on the Interval property. <gauge:SfLinearGauge VerticalOptions="Center" Interval="25" WidthRequest="500"> </gauge:SfLinearGauge> Output: Conclusion I hope you enjoyed learning how to customize the interval between the scale labels in .NET MAUI LinearGauge (SfLinearGauge). Refer to our .NET MAUI LinearGauge’s feature tour page for other groundbreaking feature representations. You can also explore our .NET MAUI LinearGauge documentation to understand how to present and manipulate data. For current customers, check out our .NET MAUI components from the License and Downloads page. If you are new to Syncfusion, try our 30-day free trial to check out our .NET MAUI LinearGauge and other .NET MAUI components. Please let us know in the following comment section if you have any queries or require clarifications. Contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
Syncfusion® Essential® DocIO is a .NET Core Word library used to create, read, and edit Word documents programmatically without Microsoft Word or Interop dependencies. Using this library, you can set Y-axis interval for column charts in the Word document in C#. Steps to set Y-axis interval for column charts in the Word document Create a new C# .NET Core console application project. Install the Syncfusion.DocIO.Net.Core NuGet package as a reference to your .NET Core applications from NuGet.org. Include the following namespace in the Program.cs file. C# using Syncfusion.DocIO; using Syncfusion.DocIO.DLS; using Syncfusion.OfficeChart; Set the MinimumValue, MaximumValue, and MajorUnit of the Y-axis interval. C# //Set the minimum and maximum value of the Y-Axis. chart.PrimaryValueAxis.MinimumValue = 0; chart.PrimaryValueAxis.MaximumValue = 1600; //Sets the interval for Y-Axis. chart.PrimaryValueAxis.MajorUnit = 200; Use the following code example to set Y-axis interval for column charts in the Word document. C# //Create a new Word document. using (WordDocument document = new WordDocument()) { //Add a section to the document. IWSection section = document.AddSection(); //Add a paragraph to the section. IWParagraph paragraph = section.AddParagraph(); //Create and append the chart to the paragraph. WChart chart = paragraph.AppendChart(446, 270); //Set chart type. chart.ChartType = OfficeChartType.Column_Clustered; //Set chart data. chart.ChartData.SetValue(1, 1, "Items"); chart.ChartData.SetValue(1, 2, "Amount(in $)"); chart.ChartData.SetValue(1, 3, "Count"); chart.ChartData.SetValue(2, 1, "Beverages"); chart.ChartData.SetValue(2, 2, 277); chart.ChartData.SetValue(2, 3, 925); chart.ChartData.SetValue(3, 1, "Condiments"); chart.ChartData.SetValue(3, 2, 177); chart.ChartData.SetValue(3, 3, 378); chart.ChartData.SetValue(4, 1, "Confections"); chart.ChartData.SetValue(4, 2, 387); chart.ChartData.SetValue(4, 3, 880); chart.ChartData.SetValue(5, 1, "Dairy Products"); chart.ChartData.SetValue(5, 2, 1008); chart.ChartData.SetValue(5, 3, 581); chart.ChartData.SetValue(6, 1, "Grains/Cereals"); chart.ChartData.SetValue(6, 2, 1500); chart.ChartData.SetValue(6, 3, 189); //Set chart series in the column for assigned data region. chart.IsSeriesInRows = false; IOfficeChartSerie serie1 = chart.Series.Add("Amount(in $)"); //Set the data range of chart series – start row, start column, end row, end column. serie1.Values = chart.ChartData[2, 2, 6, 2]; IOfficeChartSerie serie2 = chart.Series.Add("Count"); //Set the data range of chart series – start row, start column, end row, end column. serie2.Values = chart.ChartData[2, 3, 6, 3]; //Set Datalabels. chart.PrimaryCategoryAxis.CategoryLabels = chart.ChartData[2, 1, 6, 1]; //Apply chart elements. //Set Chart Title. chart.ChartTitle = "Clustered Column Chart"; //Set the minimum and maximum value of the Y-Axis. chart.PrimaryValueAxis.MinimumValue = 0; chart.PrimaryValueAxis.MaximumValue = 1600; //Sets the interval for Y-Axis. chart.PrimaryValueAxis.MajorUnit = 200; serie1.DataPoints.DefaultDataPoint.DataLabels.IsValue = true; serie2.DataPoints.DefaultDataPoint.DataLabels.IsValue = true; serie1.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center; serie2.DataPoints.DefaultDataPoint.DataLabels.Position = OfficeDataLabelPosition.Center; //Set Legend. chart.HasLegend = true; chart.Legend.Position = OfficeLegendPosition.Bottom; //Create a file stream. using (FileStream outputFileStream = new FileStream(Path.GetFullPath(@"../../../Sample.docx"), FileMode.Create, FileAccess.ReadWrite)) { //Save the Word document to the file stream. document.Save(outputFileStream, FormatType.Docx); } } Similarly, set Y-axis interval for all types of column charts, line charts, clustered cones, cylinder, and pyramid charts. A complete working sample to set Y-axis interval for column charts in the Word document in C# can be downloaded from GitHub. By executing the program, you will get the output document as follows. Take a moment to peruse the documentation, where you can find basic Word document processing options along with the features like mail merge, merge and split documents, find and replace text in the Word document, protect the Word documents, and most importantly, the PDF and Image conversions with code examples. Explore more about the rich set of Syncfusion® Word Framework features. See Also: How to set Date format in X axis of chart in Word document? How to change scatter chart marker color for each data points in Word document? Conclusion Hope you enjoyed learning about how to set Y-axis interval for column charts in Word document. You can refer to our ASP.NET Core DocIO’s feature tour page to know about its other groundbreaking feature representations. You can explore our ASP.NET Core DocIO documentation to understand how to present and manipulate data. For current customers, you can check out our ASP.NET Core components from the License and Downloads page. If you are new to Syncfusion®, you can try our 30-day free trial to check out our ASP.NET Core DocIO and other ASP.NET Core components. If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
Add the weekly recurrence appointment to the SfScheduler with the help of RecurrenceRule. Please refer to the user guide documentation for the recurrence property and its purpose. C# Create the recurrence appointment in the ViewModel with the help of RecurrenceRule. public class SchedulerViewModel : INotifyPropertyChanged { private ScheduleAppointmentCollection scheduleAppointmentCollection; public SchedulerViewModel() { this.ScheduleAppointmentCollection = new ScheduleAppointmentCollection(); var scheduleAppointment = new ScheduleAppointment() { Id = 1, StartTime = DateTime.Today.AddHours(11), EndTime = DateTime.Today.AddHours(12), Subject = "Occurs weekly On Monday and Wednesday", }; scheduleAppointment.RecurrenceRule = "FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,WE;COUNT=10"; ScheduleAppointmentCollection.Add(scheduleAppointment); } public ScheduleAppointmentCollection ScheduleAppointmentCollection { get { return this.scheduleAppointmentCollection; } set { this.scheduleAppointmentCollection = value; this.RaiseOnPropertyChanged("ScheduleAppointmentCollection"); } } public event PropertyChangedEventHandler PropertyChanged; private void RaiseOnPropertyChanged(string propertyName) { this.PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName)); } } XAML Binding ScheduleAppointmentCollection to Scheduler. <syncfusion:SfScheduler x:Name="Schedule" FirstDayOfWeek="Monday" ViewType="Week" ItemsSource="{Binding ScheduleAppointmentCollection}"> <syncfusion:SfScheduler.AppointmentMapping> <syncfusion:AppointmentMapping StartTime="From" EndTime="To" Subject="EventName" /> </syncfusion:SfScheduler.AppointmentMapping> </syncfusion:SfScheduler> View Sample in GitHub
In this article, we explaine how to render date time values in the cartesian chart with interval in hours. Our Flutter Cartesian chart provides DateTimeAxis support to render the date-time values. By default interval type will be calculated based on the data. If you wish to calculate the interval on specific type say for example month, hours, seconds, etc, then intervalType property can be used and if you wish to show the date time values in a specific format means, you can use the dateFormat property. Refer the following instructions, to render date time values in the cartesian chart with interval in hours. Step 1: Initialize the data source with required x (date-time) and y values. List<ChartSampleData> chartData = <ChartSampleData>[ ChartSampleData(x: DateTime(2015, 1, 1, 1), yValue: 1.13), ChartSampleData(x: DateTime(2015, 1, 2, 2), yValue: 1.12), ChartSampleData(x: DateTime(2015, 1, 3, 3), yValue: 1.08), ChartSampleData(x: DateTime(2015, 1, 4, 4), yValue: 1.12), ChartSampleData(x: DateTime(2015, 1, 5, 5), yValue: 1.1), ChartSampleData(x: DateTime(2015, 1, 6, 6), yValue: 1.12), ChartSampleData(x: DateTime(2015, 1, 7, 7), yValue: 1.1), ChartSampleData(x: DateTime(2015, 1, 8, 8), yValue: 1.12), ChartSampleData(x: DateTime(2015, 1, 9, 9), yValue: 1.16), ChartSampleData(x: DateTime(2015, 1, 10, 10), yValue: 1.1), ]; Step 2: Initialize the SfCartesianChart widget with the required properties along with x-axis as DateTimeAxis. SfCartesianChart( primaryXAxis: DateTimeAxis(), series: <LineSeries<ChartSampleData, DateTime>>[ LineSeries<ChartSampleData, DateTime>( dataSource: chartData, xValueMapper: (ChartSampleData sales, _) => sales.x, yValueMapper: (ChartSampleData sales, _) => sales.yValue ) ] ) Step 3: Specify the interval type as hours to display interval in hours and render the chart. primaryXAxis: DateTimeAxis( //Specified date time interval type in hours intervalType: DateTimeIntervalType.hours ), To know more about date time axis: https://help.syncfusion.com/flutter/cartesian-charts/axis-types#date-time-axis Screenshot View the sample in GitHub.ConclusionI hope you enjoyed learning about how to render Flutter time series chart using the charts widget (SfCartesianChart).You can refer to our Flutter CartesianChart feature tour page to know about its other groundbreaking feature representations. You can also explore our Flutter CartesianChart documentation to understand how to create and manipulate data.For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion®, you can try our 30-day free trial to check out our other controls.If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
By default, the interval to increment or decrement the value of TimeSpanEdit will be 1(one). We can increment or decrement an interval value of TimeSpanEdit by handling PreviewMouseDown event. In this example, value(minutes) of TimeSpanEdit will be incremented or decremented using PreviewMouseDown event. Output:
To set the intervals of the Ticks along the track in the SfRadialSlider, TickFrequency property can be used. The same has been demonstrated in the following code example. XAML: C#:
Syncfusion Excel (XlsIO) library is a .NET Excel library used to create, read, and edit Excel documents. Also, converts Excel documents to PDF files. Using this library, you can set the axis interval in terms of days, months or years. Steps to set the axis interval in terms of days, programmatically: Create a new C# console application project. Create a new C# console application project Install the Syncfusion.XlsIO.WinForms NuGet package as reference to your .NET Framework application from NuGet.org. Install NuGet package to the project Add an Excel file to you project and make it an embedded resource using the following steps. In Visual Studio, click the Project menu and select Add Existing Item. Find and select the Excel file you want to add to your project. In the Solution Explorer window, right-click on the Excel file you just added to your project and select Properties from the popup menu. The Properties tool window appears. In the Properties window, change the Build Action property to Embedded Resource. Build the project. The Excel file will be compiled into your project’s assembly. Include the following namespaces in Program.cs file. C# using Syncfusion.XlsIO; using System.IO; using System.Reflection; VB.NET Imports Syncfusion.XlsIO Imports System.IO Imports System.Reflection You can set the interval unit for chart category axis through the BaseUnit property of IChartCategoryAxis interface. Interval units are available under ExcelChartBaseUnit enum. You cannot set this property to value axis. C# //Set the base unit as Day chart.PrimaryCategoryAxis.BaseUnit = ExcelChartBaseUnit.Day; VB.NET 'Set the base unit as Day chart.PrimaryCategoryAxis.BaseUnit = ExcelChartBaseUnit.Day Note that this will take effect only if you set the CategoryType property to Time scale. Category types are available under the enum ExcelCategoryType. C# //Assign the category type chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Time; VB.NET 'Assign the category type chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Time Include the following code snippet in main method of Program.cs file to set the axis interval in terms of days. C# using (ExcelEngine excelEngine = new ExcelEngine()) { //Instantiate the Excel application object IApplication application = excelEngine.Excel; //Load an existing Excel file into IWorkbook Assembly assembly = typeof(Program).GetTypeInfo().Assembly; Stream fileStream = assembly.GetManifestResourceStream("AxisInterval.Sample.xlsx"); IWorkbook workbook = application.Workbooks.Open(fileStream, ExcelOpenType.Automatic); //Get the first worksheet in workbook into IWorksheet IWorksheet worksheet = workbook.Worksheets[0]; //Add a chart in the worksheet IChartShape chart = worksheet.Charts.Add(); //Set the data range and title to the chart chart.DataRange = worksheet.Range["A2:C12"]; chart.ChartTitle = "Texas Books Unit Sales"; //Assign the number format and category type for category axis chart.PrimaryCategoryAxis.NumberFormat = "dd-MMM"; chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Time; //Set the axis to 3-days interval chart.PrimaryCategoryAxis.BaseUnitIsAuto = false; chart.PrimaryCategoryAxis.BaseUnit = ExcelChartBaseUnit.Day; chart.PrimaryCategoryAxis.MajorUnitScale = ExcelChartBaseUnit.Day; chart.PrimaryCategoryAxis.MajorUnit = 3; //Set the titles for category axis and value axis chart.PrimaryCategoryAxis.Title = "City"; chart.PrimaryValueAxis.Title = "Sales"; //Set the chart series in column for assigned data region chart.IsSeriesInRows = false; //Set the position for chart in the worksheet chart.TopRow = 2; chart.LeftColumn = 5; chart.BottomRow = 16; chart.RightColumn = 13; //Save the Excel workbook workbook.SaveAs("Output.xlsx"); } VB.NET Using excelEngine As ExcelEngine = New ExcelEngine() 'Instantiate the Excel application object Dim application As IApplication = excelEngine.Excel 'Load an existing Excel file into IWorkbook Dim assembly As Assembly = GetType(Module1).GetTypeInfo.Assembly Dim fileStream As Stream = assembly.GetManifestResourceStream("AxisInterval.Sample.xlsx") Dim workbook As IWorkbook = application.Workbooks.Open(fileStream, ExcelOpenType.Automatic) 'Get the first worksheet in workbook into IWorksheet Dim worksheet As IWorksheet = workbook.Worksheets(0) 'Add a chart in the worksheet Dim chart As IChartShape = worksheet.Charts.Add 'Set the data range and title to the chart chart.DataRange = worksheet.Range("A2:C12") chart.ChartTitle = "Texas Books Unit Sales" 'Assign the number format and category type for category axis chart.PrimaryCategoryAxis.NumberFormat = "dd-MMM" chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Time 'Set the axis to 3-days interval chart.PrimaryCategoryAxis.BaseUnitIsAuto = False chart.PrimaryCategoryAxis.BaseUnit = ExcelChartBaseUnit.Day chart.PrimaryCategoryAxis.MajorUnitScale = ExcelChartBaseUnit.Day chart.PrimaryCategoryAxis.MajorUnit = 3 'Set the titles for category axis and value axis chart.PrimaryCategoryAxis.Title = "City" chart.PrimaryValueAxis.Title = "Sales" 'Set the chart series in column for assigned data region chart.IsSeriesInRows = False 'Set the position for chart in the worksheet chart.TopRow = 2 chart.LeftColumn = 5 chart.BottomRow = 16 chart.RightColumn = 13 'Save the Excel workbook workbook.SaveAs("Output.xlsx") End Using A complete working sample to set the axis interval in terms of days can be downloaded from Axis-Interval.zip. By executing the program, you will get the output Excel document as follows. Output Excel document Take a moment to peruse the documentation where you will find other options like creating and removing a chart, customizing chart and chart elements, sparkline, excel 2016 charts and creation of all supported chart types. Click here to explore the rich set of Syncfusion Excel (XlsIO) library features. An online sample link to create a chart worksheet. Note:Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer the link to learn about generating and registering Syncfusion license key in your application to use the components without trial message. ConclusionI hope you enjoyed learning how to set the axis interval in terms of days in C#, VB.NET.You can refer to our WinForms Excel feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WinForms Excel example to understand how to create and manipulate data.For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
