GrapeCity.Documents.Excel.Drawing.IPivotOptions.ShowAxisFieldButtons

ShowAxisFieldButtons Property

ShowAxisFieldButtons

Gets or sets whether the axis field buttons are displayed on a PivotChart.

Declaration

bool ShowAxisFieldButtons { get; set; }

Property ShowAxisFieldButtons As Boolean

Examples

object[,] sourceData = {{"Category", "Amount"}, {"Beverages", 100}, {"Snacks", 200}};
worksheet.Range["A1:B3"].Value = sourceData;
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
pivotTable.PivotFields["Category"].Orientation = PivotFieldOrientation.RowField;
pivotTable.PivotFields["Amount"].Orientation = PivotFieldOrientation.DataField;
IChart chart = worksheet.Shapes.AddChartInPixel(ChartType.ColumnClustered, 0, 100, 360, 240).Chart;
chart.SetSourceData(pivotTable.TableRange1);
bool showAxisButtons = chart.PivotOptions.ShowAxisFieldButtons;