I have ASPOSE.Cells for .NET 6.0.1. I am creating a radar chart and converting it to an emf image with the following code. While creating the chart I set the CategoryAxis.IsVisible value to False. The chart in the xlsx file looks correct, but the image is still showing the Category Axis Values. Am I missing something. I have attached the xlsx and a png. I am creating an emf in my code, but I could not upload that image and png had the same issue. I had done the same thing with a line chart with no issues. I have attached the xlsx document and the .png image. Thanks for your help. Here is my code.
Dim workbook As Workbook = New Workbook
Dim sheetIndex As Integer = workbook.Worksheets.Add()
Dim worksheet As Worksheet = workbook.Worksheets(sheetIndex)
Dim intLoop As Integer
worksheet.Cells(0, 0).PutValue(1)
worksheet.Cells(89, 0).PutValue(1)
worksheet.Cells(180, 0).PutValue(1)
worksheet.Cells(272, 0).PutValue(1)
worksheet.Cells(0, 1).PutValue(2)
worksheet.Cells(89, 1).PutValue(2)
worksheet.Cells(180, 1).PutValue(2)
worksheet.Cells(272, 1).PutValue(2)
'Adding a chart to the worksheet
Dim chartIndex As Integer = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Radar, 3, 3, 20, 10)
'Accessing the instance of the newly added chart
Dim chart As Aspose.Cells.Charts.Chart = worksheet.Charts(chartIndex)
'Adding SeriesCollection for inner dots
chart.NSeries.Add("A1:A361", True)
'Adding SeriesCollection for outer dots
chart.NSeries.Add("B1:B361", True)
chart.ChartArea.Area.Formatting = FormattingType.None
chart.ChartArea.Border.IsVisible= False
chart.Legend.IsAutomaticSize = False
chart.Legend.Height = 0
chart.Legend.Width = 0
'Set min and max values
chart.ValueAxis.MaxValue = 2
chart.ValueAxis.MinValue = 0
'Value Axis Values
chart.ValueAxis.MajorGridLines.IsVisible = False
chart.ValueAxis.MinorGridLines.IsVisible = False
chart.ValueAxis.MajorTickMark = TickMarkType.None
chart.ValueAxis.MinorTickMark = TickMarkType.None
chart.ValueAxis.IsVisible = False
chart.CategoryAxis.IsVisible = False
chart.PlotArea.Area.Formatting = FormattingType.None
chart.PlotArea.Border.IsVisible = False
chart.NSeries(0).MarkerStyle = ChartMarkerType.Circle
chart.NSeries(0).MarkerSize = 8
chart.NSeries(0).MarkerForegroundColor = System.Drawing.Color.Black
chart.NSeries(0).MarkerBackgroundColor = System.Drawing.Color.Black
chart.NSeries(0).Line.IsVisible = False
chart.NSeries(1).MarkerStyle = ChartMarkerType.Circle
chart.NSeries(1).MarkerSize = 8
chart.NSeries(1).MarkerForegroundColor = System.Drawing.Color.Black
chart.NSeries(1).MarkerBackgroundColor = System.Drawing.Color.Black
chart.NSeries(1).Line.IsVisible = False
chart.ToImage("C:\radartest.emf", System.Drawing.Imaging.ImageFormat.Emf)
workbook.Save("C:\radartest.xlsx", Aspose.Cells.SaveFormat.Xlsx)