Skip to main content

Chart Creation and Editing

APIDescriptionExample
Worksheet.ChartObjectsFunction that returns chart management object within sheet
cf) When index is passed as parameter, returns chart object of that index		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;

let chartObjects = activeSheet.ChartObjects(); // Return chart management object
let chartObject = activeSheet.ChartObjects(1); // Return chart object of specific index
ChartObjects.CountProperty that returns the number of chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Count);
ChartObjects.HeightProperty that returns the height of the first chart or changes the height of all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Height); // Outputs only the height of the first chart to console
chartObjects.Height = 200; // Changes the height of all charts
ChartObjects.LeftFirst chart's X coordinate or changes the X coordinate of all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Left); // Outputs only the X coordinate of the first chart to console
chartObjects.Left = 100; // Changes the X coordinate of all charts
ChartObjects.TopProperty that returns the Y coordinate of the first chart or changes the Y coordinate of all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Top); // Outputs only the Y coordinate of the first chart to console
chartObjects.Top = 100; // Changes the Y coordinate of all charts
ChartObjects.VisibleProperty that returns the visibility state of the first chart or changes the visibility state of all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Visible); // Outputs only the visibility state of the first chart to console
chartObjects.Visible = false; // Changes the visibility state of all charts
ChartObjects.WidthProperty that returns the width of the first chart or changes the width of all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

console.log(chartObjects.Width); // Outputs only the width of the first chart to console
chartObjects.Width = 100; // Changes the width of all charts
ChartObjects.AddFunction that adds a chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

let chartObject = chartObjects.Add(50, 50, 100, 150);
ChartObject.BottomRightCellProperty that returns the range object corresponding to the bottom-right cell of the chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

let cell = chartObject.BottomRightCell;
ChartObject.ChartProperty that returns the object that manages the chart's attributeslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

let chart = chartObject.Chart;
Chart.ChartAreaProperty that returns the object that manages the chart arealet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let chartArea = chart.ChartArea;
ChartArea.FormatProperty that returns the object that manages the format of the chart arealet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartArea = chart.ChartArea;

let chartFormat = chartArea.Format;
ChartFormat.FillProperty that returns the chart's fill format object
cf) Detailed API is organized under the Shape.Fill API		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartArea = chart.ChartArea;
let chartFormat = chartArea.Fill;

let fillFormat = chartFormat.Fill;
Chart.ChartStyleProperty that returns or changes the chart's style
cf) Numeric value between 1 and 48, inclusive		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.ChartStyle);
chart.ChartStyle = 15;
Chart.ChartTitleProperty that returns the object that manages the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let chartTitle = chart.ChartTitle;
ChartTitle.CaptionProperty that returns or changes the chart title stringlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Caption);
chartTitle.Caption = "Chart Title";
ChartTitle.HeightProperty that returns the chart title's heightlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Height);
ChartTitle.LeftProperty that returns or changes the X coordinate of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Left);
chartTitle.Left += 10;
ChartTitle.NameProperty that returns the name of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Name);
ChartTitle.OrientationProperty that returns or changes the orientation of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Orientation);
chartTitle.Orientation = instance.Enums.XlOrientation.xlHorizontal;
ChartTitle.PositionProperty that returns or changes the position setting method of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Position);
chartTitle.Position = instance.Enums.XlChartElementPosition.xlChartElementPositionAutomatic;
ChartTitle.TextProperty that returns or changes the chart title stringlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Text);
chartTitle.Text = "Chart Title";
ChartTitle.TopProperty that returns or changes the Y coordinate of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Top);
chartTitle.Top += 10;
ChartTitle.WidthProperty that returns the width of the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

console.log(chartTitle.Width);
ChartTitle.DeleteFunction that removes the chart titlelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

chartTitle.Delete();
ChartTitle.SelectFunction that processes the chart title as selected.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let chartTitle = chart.ChartTitle;

chartTitle.Select();
Chart.ChartTypeAn attribute that returns or changes the chart type.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.ChartType);
chart.ChartType = instance.Enums.XlChartType.xlColumnStacked;
Chart.HasLegendAn attribute that returns or changes whether the chart legend exists.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.HasLegend);
chart.HasLegend = true;
Chart.HasTitleAn attribute that returns or changes whether the chart title exists.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.HasTitle);
chart.HasTitle = true;
Chart.IndexAn attribute that returns the chart index.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.Index);
Chart.LegendAn attribute that returns the object that manages the chart legend.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let legend = chart.Legend;
Legend.HeightAn attribute that returns or changes the chart legend's height.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

console.log(legend.Height);
legend.Height += 10;
Legend.LeftAn attribute that returns or changes the chart legend's X coordinate.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

console.log(legend.Left);
legend.Left += 10;
Legend.PositionProperty that returns or changes the position setting method of the chart legendlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

console.log(legend.Position); legend.Position = instance.Enums.XlLegendPosition.xlLegendPositionTop;
Legend.TopProperty that returns or changes the Y coordinate of the chart legendlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

console.log(legend.Top); legend.Top += 10;
Legend.WidthProperty that returns or changes the width of the chart legendlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

console.log(legend.Width);
legend.Width += 10;
Legend.DeleteFunction that removes the chart legendlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

legend.Delete();
Legend.SelectFunction that selects the chart legendlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let legend = chart.Legend;

legend.Select();
Chart.NameProperty that returns or changes the name of the chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.Name);
chart.Name = "Chart 1";
Chart.PlotAreaProperty that returns the object that manages the area where the chart is drawnlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let plotArea = chart.PlotArea;
PlotArea.HeightProperty that returns or changes the height of the area where the chart is drawnlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let plotArea = chart.PlotArea;

console.log(plotArea.Height);
plotArea.Height += 10;
PlotArea.LeftProperty that returns or changes the X coordinate of the area where the chart is drawnlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let plotArea = chart.PlotArea;

console.log(plotArea.Left);
plotArea.Left += 10;
PlotArea.TopAn attribute that returns or changes the Y coordinate of the area where the chart is drawn.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let plotArea = chart.PlotArea;

console.log(plotArea.Top);
plotArea.Top += 10;
PlotArea.WidthAn attribute that returns or changes the width of the area where the chart is drawn.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let plotArea = chart.PlotArea;

console.log(plotArea.Width);
plotArea.Width += 10;
Chart.PlotByAn attribute that returns or changes the standard or basis for drawing the chart.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.PlotBy);
chart.PlotBy = instance.Enums.XlRowCol.xlRows;
Chart.VisibleAn attribute that returns or changes the chart's display status.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.Visible);
chart.Visible = instance.Enums.XlSheetVisibility.xlSheetHidden;
Chart.HasAxisFunction that returns whether a specific type of axis exists in the chart.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

console.log(chart.HasAxis(instance.Enumx.XlAxisType.xlCategory));
Chart.SetHasAxisFunction that changes whether a specific type of axis exists in the chart.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.SetHasAxis({
Index1: instance.Enums.XlAxisType.xlCategory,
RHS: false
});
Chart.ApplyLayoutFunction that changes the chart's layout.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.ApplyLayout(1);
Chart.AxesFunction that returns the object that manages the chart axis.
cf) Returns the chart axis object at the specified index when passing the index as a parameter.		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let axes = chart.Axes();
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
Axes.CountAn attribute that returns the number of chart axes.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axes = chart.Axes();

console.log(axes.Count);
Axes.ItemFunction that returns the chart axis object at the specified index.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axes = chart.Axes();

let axis = axes.Item(instance.Enums.XlAxisType.xlCategory);
Axis.AxisBetweenCategoriesAn attribute that returns or changes whether the chart axis crosses the category axis between categories.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.AxisBetweenCategories);
axis.AxisBetweenCategories = true;
Axis.AxisTitleAn attribute that returns the object that manages the chart axis title.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

let axisTitle = axis.AxisTitle;
AxisTitle.CaptionAn attribute that returns or changes the chart axis title string.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Caption);
axisTitle.Caption = "Axis Title";
AxisTitle.HeightAn attribute that returns the chart axis title height.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Height);
AxisTitle.LeftAn attribute that returns or changes the chart axis title's X coordinate.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Left);
axisTitle.Left += 5;
AxisTitle.PositionAn attribute that returns or changes the chart axis title's position setting method.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Position);
axisTitle.Position = instance.Enums.XlChartElementPosition.xlChartElementPositionAutomatic;
AxisTitle.TextAn attribute that returns or changes the chart axis title string.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Text);
axisTitle.Text = "Axis Title";
AxisTitle.TopAn attribute that returns or changes the chart axis title's Y coordinate.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Top);
axisTitle.Top =+ 5;
AxisTitle.WidthAn attribute that returns the chart axis title's width.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

console.log(axisTitle.Width);
AxisTitle.DeleteFunction that removes the chart axis title.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

axisTitle.Delete();
AxisTitle.SelectFunction that processes the chart axis title as selected.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);
let axisTitle = axis.AxisTitle;

axisTitle.Select();
Axis.BaseUnitAn attribute that returns or changes the chart axis's base unit.
cf) Operates normally when the chart category axis type (Axis.CategoryType) is the Date Axis(instance.Enums.XlCategoryType.xlTimeScale).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.BaseUnit);
axis.BaseUnit = instance.Enums.XlTimeUnit.xlDays;
Axis.BaseUnitIsAutoAn attribute that returns or changes whether to automatically determine the chart axis's base unit.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.BaseUnitIsAuto);
axis.BaseUnitIsAuto = true;
Axis.CategoryNamesAn attribute that returns or changes the chart category axis name.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.CategoryNames);
axis.CategoryNames = [ "1985", "1986" ];
Axis.CategoryTypeAn attribute that returns or changes the chart category axis type.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.CategoryType);
axis.CategoryType = instance.Enums.XlCategoryType.xlTimeScale;
Axis.DisplayUnitAn attribute that returns or changes the chart axis's display unit.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.DisplayUnit);
axis.DisplayUnit = instance.Enums.XlDisplayUnit.xlHundreds;
Axis.HasDisplayUnitLabelAn attribute that returns or changes whether the chart axis's display unit label exists.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.HasDisplayUnitLabel);
axis.HasDisplayUnitLabel = true;
Axis.HasTitleAn attribute that returns or changes whether the chart axis title exists.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.HasTitle);
axis.HasTitle = true;
Axis.HeightAn attribute that returns the chart axis height.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.Height);
Axis.LeftAn attribute that returns the chart axis's X coordinate.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.Left);
Axis.LogBaseAn attribute that returns or changes the chart axis's logarithm base.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.LogBase);
axis.LogBase = 10;
Axis.MajorTickMarkAn attribute that returns or changes the chart axis's major tick mark type.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MajorTickMark);
axis.MajorTickMark = instance.Enums.XlTickMark.xlTickMarkInside;
Axis.MajorUnitAn attribute that returns or changes the chart axis's major unit.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MajorUnit);
axis.MajorUnit = 1000;
Axis.MajorUnitIsAutoAn attribute that returns or changes whether to automatically determine the chart axis's major unit.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MajorUnitIsAuto);
axis.MajorUnitIsAuto = true;
Axis.MajorUnitScaleAn attribute that returns or changes the chart axis's major unit.
cf) Operates normally when the chart category axis type (Axis.CategoryType) is the Date Axis (instance.Enums.XlCategoryType.xlTimeScale).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.MajorUnitScale);
axis.MajorUnitScale = instance.Enums.XlTimeUnit.xlDays;
Axis.MaximumScaleAn attribute that returns or changes the chart axis's maximum value.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MaximumScale);
axis.MaximumScale = 10000;
Axis.MaximumScaleIsAutoAn attribute that returns or changes whether to automatically determine the chart axis's maximum value.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.MaximumScaleIsAuto);
axis.MaximumScaleIsAuto = true;
Axis.MinimumScaleAn attribute that returns or changes the chart axis's minimum value.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MinimumScale);
axis.MinimumScale = 100;
Axis.MinimumScaleIsAutoAn attribute that returns or changes whether to automatically determine the chart axis's minimum value.let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.MinimumScaleIsAuto);
axis.MinimumScaleIsAuto = true;
Axis.MinorTickMarkAn attribute that returns or changes the chart axis's minor tick mark type.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MinorTickMark);
axis.MinorTickMark = instance.Enums.XlTickMark.xlTickMarkInside;
Axis.MinorUnitAn attribute that returns or changes the chart axis's minor unit.
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MinorUnit);
axis.MinorUnit = 10;
Axis.MinorUnitIsAutoAn attribute that returns or changes whether to automatically determine the chart axis's minor unitlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.MinorUnitIsAuto);
axis.MinorUnitIsAuto = true;
Axis.MinorUnitScaleAn attribute that returns or changes the chart axis's minor unit
cf) Operates normally when the chart category axis type (Axis.CategoryType) is the Date Axis (instance.Enums.XlCategoryType.xlTimeScale).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.MinorUnitScale);
axis.MinorUnitScale = instance.Enums.XlTimeUnit.xlDays;
Axis.ReversePlotOrderAn attribute that returns or changes whether to reverse the chart axis plotting orderlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.ReversePlotOrder);
axis.ReversePlotOrder = true;
Axis.ScaleTypeAn attribute that returns or changes the chart axis's scale type
cf) Operates normally when the chart axis type is the Value Axis (instance.Enums.XlAxisType.xlValue).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlValue);

console.log(axis.ScaleType);
axis.ScaleType = instance.Enums.XlScaleType.xlScaleLogarithmic;
Axis.TickLabelPositionAn attribute that returns or changes the chart axis's tick label positionlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.TickLabelPosition);
axis.TickLabelPosition = instance.Enums.XlTickLabelPosition.xlTickLabelPositionHigh;
Axis.TickLabelSpacingAn attribute that returns or changes the number of categories between tick labels on the chart axis
cf) Operates normally when the chart category axis type (Axis.CategoryType) is not the Date Axis (instance.Enums.XlCategoryType.xlTimeScale).		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.TickLabelSpacing);
axis.TickLabelSpacing = 1;
Axis.TickLabelSpacingIsAutoAn attribute that returns or changes whether to automatically determine the number of categories between tick labels on the chart axislet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.TickLabelSpacingIsAuto);
axis.TickLabelSpacingIsAuto = true;
Axis.TopAn attribute that returns the chart axis's X coordinatelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.Top);
Axis.WidthAn attribute that returns the chart axis's widthlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

console.log(axis.Width);
Axis.DeleteFunction that removes the chart axislet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let axis = chart.Axes(instance.Enums.XlAxisType.xlCategory);

axis.Delete();
Chart.ClearToMatchStyleFunction that removes the applied chart format and changes it to an appropriate stylelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.ClearToMatchStyle();
Chart.RefreshFunction that refreshes the chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.Refresh();
Chart.SelectFunction that processes the chart as selectedlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.Select();
Chart.SeriesCollectionFunction that returns the object that manages chart series
cf) Returns the chart series object at the specified index when passing the index as a parameter		let workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

let seriesCollection = chart.SeriesCollection();
let series = chart.SeriesCollection(1);
SeriesCollection.CountProperty that returns the number of chart serieslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let seriesCollection = chart.SeriesCollection();

console.log(seriesCollection.Count);
SeriesCollection.AddFunction that adds a chart serieslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let seriesCollection = chart.SeriesCollection();

let series = seriesCollection.Add(activeSheet.Range("B1:B10"));
SeriesCollection.ItemFunction that returns the chart series object at the specified indexlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let seriesCollection = chart.SeriesCollection();

let series = seriesCollection.Item(1);
Series.BorderProperty that returns the chart series' border objectlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

let border = series.Border;
Series.BubbleSizesProperty that returns or changes the range containing the X value, Y value, and size data for the bubble chart as a stringlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.BubbleSizes);
series.BubbleSizes = "Sheet1!R1C5:R5:C5";
Series.ExplosionProperty that returns or changes the separation distance for pie and donut chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.Explosion);
series.Explosion = 30;
Series.HasErrorBarsProperty that returns or changes whether error bars exist in the chart serieslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.HasErrorBars);
series.HasErrorBars = true;
Series.InvertIfNegativeProperty that returns or changes whether to invert the pattern when the chart series data is negativelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.InvertIfNegative);
series.InvertIfNegative = true;
Series.TypeProperty that returns or changes the chart series typelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.Type);
series.Type = instance.Enums.XlChartType.xlLine;
Series.ValuesProperty that returns or changes the chart series datalet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.Values);
series.Values = [ 1, 2 ];
Series.XValuesProperty that returns or changes the chart series' X valueslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

console.log(series.XValues);
series.XValues = [ "A", "B" ];
Series.ClearFormatsFunction that removes the chart series' formatlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

series.ClearFormats();
Series.DeleteFunction that removes the chart serieslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

series.Delete();
Series.SelectFunction that processes the chart series as selectedlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let series = chart.SeriesCollection(1);

series.Select();
SeriesCollection.NewSeriesFunction that adds a new chart serieslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;
let seriesCollection = chart.SeriesCollection();

let series = seriesCollection.NewSeries();
Chart.SetSourceDataFunction that changes the chart's source data rangelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);
let chart = chartObject.Chart;

chart.SetSourceData(activeSheet.Range("A1:B3"));
ChartObject.HeightProperty that returns or changes the chart's heightlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Height);
chartObject.Height = 150;
ChartObject.IndexProperty that returns the chart's indexlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Index);
ChartObject.LeftProperty that returns or changes the chart's X coordinatelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Left);
chartObject.Left = 100;
ChartObject.NameProperty that returns or changes the name of the chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Name);
chartObject.Name = "Chart 1";
ChartObject.TopProperty that returns or changes the chart's Y coordinatelet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Top);
chartObject.Top = 100;
ChartObject.TopLeftCellProperty that returns the range object corresponding to the chart's top-left celllet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

let cell = chartObject.TopLeftCell;
ChartObject.VisibleProperty that returns or changes the chart's display statuslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Visible);
chartObject.Visible = true;
ChartObject.WidthProperty that returns or changes the chart's widthlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.Width);
chartObject.Width = 200;
ChartObject.ZOrderProperty that returns the chart's Z-Orderlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

console.log(chartObject.ZOrder);
ChartObject.ActivateFunction that processes the chart as activatedlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

chartObject.Activate();
ChartObject.DeleteFunction that removes the chartlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

chartObject.Delete();
ChartObject.SelectFunction that processes the chart as selectedlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

chartObject.Select();
ChartObject.SendToBackFunction that changes the chart's Z-Order to the bottomlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();
let chartObject = chartObjects.Item(1);

chartObject.SendToBack();
ChartObjects.DeleteFunction that removes all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

chartObjects.Delete();
ChartObjects.DuplicateFunction that duplicates all chartslet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

chartObjects.Duplicate();
ChartObjects.ItemFunction that returns the chart object at the specified indexlet workbook = instance.Application.ActiveWorkbook;
let activeSheet = workbook.ActiveSheet;
let chartObjects = activeSheet.ChartObjects();

let chartObject = chartObjects.Item(1);

Visualization Tools , Sparklines , Insert Shapes and Images