Aspose::Cells::Charts::IChart Class Referenceabstract

Encapsulates the object that represents a single Excel chart. More...

Inherits Object.

Public Member Functions

virtual Aspose::Cells::Systems::Int32 GetStyle ()=0
 Gets the builtin style. More...
 
virtual void SetStyle (Aspose::Cells::Systems::Int32 value)=0
 Sets the builtin style. More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::IChartShapeGetIChartObject ()=0
 Represents the chartShape; More...
 
virtual bool GetHidePivotFieldButtons ()=0
 Indicates whether hide the pivot chart field buttons only when the chart is PivotChart More...
 
virtual void SetHidePivotFieldButtons (bool value)=0
 Indicates whether hide the pivot chart field buttons only when the chart is PivotChart More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IPivotOptionsGetIPivotOptions ()=0
 Specifies the pivot controls that appear on the chart More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetPivotSource ()=0
 The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart. More...
 
virtual void SetPivotSource (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
 The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart. More...
 
virtual bool IsChartDataChanged ()=0
 Detects if a chart's data source has changed. More...
 
virtual void RefreshPivotData ()=0
 Refreshes pivot chart's data from it's pivot data source. More...
 
virtual Aspose::Cells::Charts::PlotEmptyCellsType GetPlotEmptyCellsType ()=0
 Gets how to plot the empty cells. More...
 
virtual void SetPlotEmptyCellsType (Aspose::Cells::Charts::PlotEmptyCellsType value)=0
 Sets how to plot the empty cells. More...
 
virtual bool GetPlotVisibleCells ()=0
 Indicates whether only plot visible cells. More...
 
virtual void SetPlotVisibleCells (bool value)=0
 Indicates whether only plot visible cells. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetName ()=0
 Gets the name of the chart. More...
 
virtual void SetName (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
 Sets the name of the chart. More...
 
virtual bool GetSizeWithWindow ()=0
 True if Microsoft Excel resizes the chart to match the size of the chart sheet window. More...
 
virtual void SetSizeWithWindow (bool value)=0
 True if Microsoft Excel resizes the chart to match the size of the chart sheet window. More...
 
virtual intrusive_ptr< Aspose::Cells::IWorksheetGetIWorksheet ()=0
 Gets the worksheet which contains this chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::IShapeCollectionGetIShapes ()=0
 Returns all drawing shapes in this chart. More...
 
virtual Aspose::Cells::PrintSizeType GetPrintSize ()=0
 Gets the printed chart size. More...
 
virtual void SetPrintSize (Aspose::Cells::PrintSizeType value)=0
 Sets the printed chart size. More...
 
virtual Aspose::Cells::Charts::ChartType GetType ()=0
 Gets a chart's type. More...
 
virtual void SetType (Aspose::Cells::Charts::ChartType value)=0
 Sets a chart's type. More...
 
virtual void Move (Aspose::Cells::Systems::Int32 upperLeftRow, Aspose::Cells::Systems::Int32 upperLeftColumn, Aspose::Cells::Systems::Int32 lowerRightRow, Aspose::Cells::Systems::Int32 lowerRightColumn)=0
 Moves the chart to a specified location. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::ISeriesCollectionGetNISeries ()=0
 Gets a ISeriesCollection collection representing the data series in the chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::ITitleGetITitle ()=0
 Gets the chart's title. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IChartFrameGetIChartPlotAreaWithoutTickLabels ()=0
 Gets the chart's plot area which does not inculde axis tick lables. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IPlotAreaGetIPlotArea ()=0
 Gets the chart's plot area which includes axis tick lables. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IChartAreaGetIChartArea ()=0
 Gets the chart area in the worksheet More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IAxisGetCategoryIAxis ()=0
 Gets the chart's X axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IAxisGetValueIAxis ()=0
 Gets the chart's Y axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IAxisGetSecondValueIAxis ()=0
 Gets the chart's second Y axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IAxisGetSecondCategoryIAxis ()=0
 Gets the chart's second X axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IAxisGetSeriesIAxis ()=0
 Gets the chart's series axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::ILegendGetILegend ()=0
 Gets the chart legend. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IChartDataTableGetIChartDataTable ()=0
 Represents the chart data table. More...
 
virtual bool IsLegendShown ()=0
 Gets a value indicating whether the chart legend will be displayed. Default is true. More...
 
virtual void SetLegendShown (bool value)=0
 Sets a value indicating whether the chart legend will be displayed. Default is true. More...
 
virtual bool GetShowLegend ()=0
 Gets a value indicating whether the chart legend will be displayed. Default is true. More...
 
virtual void SetShowLegend (bool value)=0
 Sets a value indicating whether the chart legend will be displayed. Default is true. More...
 
virtual bool IsRectangularCornered ()=0
 Gets a value indicating whether the chart area is rectangular cornered. Default is true. More...
 
virtual void SetRectangularCornered (bool value)=0
 Sets a value indicating whether the chart area is rectangular cornered. Default is true. More...
 
virtual bool IsDataTableShown ()=0
 Gets a value indicating whether the chart displays a data table. More...
 
virtual void SetDataTableShown (bool value)=0
 Sets a value indicating whether the chart displays a data table. More...
 
virtual bool GetShowDataTable ()=0
 Gets a value indicating whether the chart displays a data table. More...
 
virtual void SetShowDataTable (bool value)=0
 Sets a value indicating whether the chart displays a data table. More...
 
virtual Aspose::Cells::Systems::Int32 GetFirstSliceAngle ()=0
 Gets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360. More...
 
virtual void SetFirstSliceAngle (Aspose::Cells::Systems::Int32 value)=0
 Gets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360. More...
 
virtual Aspose::Cells::Systems::Int32 GetGapWidth ()=0
 Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500. More...
 
virtual void SetGapWidth (Aspose::Cells::Systems::Int32 value)=0
 Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500. More...
 
virtual Aspose::Cells::Systems::Int32 GetGapDepth ()=0
 Gets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500. More...
 
virtual void SetGapDepth (Aspose::Cells::Systems::Int32 value)=0
 Sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500. More...
 
virtual void Calculate ()=0
 Calcuate the custom position of plot area, axises if the position of them are auto assigned. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IFloorGetIFloor ()=0
 Returns a IFloor object that represents the walls of a 3-D chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IWallsGetIWalls ()=0
 Returns a IWalls object that represents the walls of a 3-D chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IWallsGetBackIWall ()=0
 Returns a IWalls object that represents the back wall of a 3-D chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::IWallsGetSideIWall ()=0
 Returns a IWalls object that represents the side wall of a 3-D chart. More...
 
virtual bool GetWallsAndGridlines2D ()=0
 True if gridlines are drawn two-dimensionally on a 3-D chart. More...
 
virtual void SetWallsAndGridlines2D (bool value)=0
 True if gridlines are drawn two-dimensionally on a 3-D chart. More...
 
virtual Aspose::Cells::Systems::Int32 GetRotationAngle ()=0
 Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). More...
 
virtual void SetRotationAngle (Aspose::Cells::Systems::Int32 value)=0
 Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). More...
 
virtual Aspose::Cells::Systems::Int32 GetRotation ()=0
 Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). More...
 
virtual void SetRotation (Aspose::Cells::Systems::Int32 value)=0
 Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). More...
 
virtual Aspose::Cells::Systems::Int32 GetElevation ()=0
 Represents the elevation of the 3-D chart view, in degrees. More...
 
virtual void SetElevation (Aspose::Cells::Systems::Int32 value)=0
 Represents the elevation of the 3-D chart view, in degrees. More...
 
virtual bool GetRightAngleAxes ()=0
 True if the chart axes are at right angles.Applies only for 3-D charts(except Column3D and 3-D Pie Charts). More...
 
virtual void SetRightAngleAxes (bool value)=0
 True if the chart axes are at right angles.Applies only for 3-D charts(except Column3D and 3-D Pie Charts). More...
 
virtual bool GetAutoScaling ()=0
 True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True. More...
 
virtual void SetAutoScaling (bool value)=0
 True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True. More...
 
virtual Aspose::Cells::Systems::Int16 GetHeightPercent ()=0
 Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). More...
 
virtual void SetHeightPercent (Aspose::Cells::Systems::Int16 value)=0
 Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). More...
 
virtual Aspose::Cells::Systems::Int16 GetPerspective ()=0
 Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True. More...
 
virtual void SetPerspective (Aspose::Cells::Systems::Int16 value)=0
 Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True. More...
 
virtual bool GetIs3D ()=0
 Indicates whether the chart is a 3d chart. More...
 
virtual Aspose::Cells::Systems::Int32 GetDepthPercent ()=0
 Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). More...
 
virtual void SetDepthPercent (Aspose::Cells::Systems::Int32 value)=0
 Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Drawing::Bitmap > ToImage ()=0
 Gets a 32-bit Bitmap object of the chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Drawing::Bitmap > ToImage (intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions > options)=0
 Gets a 32-bit Bitmap object of the chart. ImageOrPrintOptions.ImageFormat , ImageOrPrintOptions.TiffCompression and ImageOrPrintOptions.Quality attributes are ignored. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::String > imageFile)=0
 Creates the chart image and saves it to a file. The extension of the file name determines the format of the image. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::String > imageFile, intrusive_ptr< Aspose::Cells::Systems::Drawing::Imaging::ImageFormat > imageFormat)=0
 Creates the chart image and saves it to a file in the specified format. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::String > imageFile, Aspose::Cells::Systems::Int64 jpegQuality)=0
 Creates the chart image and saves it to a file in the Jpeg format. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream, Aspose::Cells::Systems::Int64 jpegQuality)=0
 Creates the chart image and saves it to a stream in the Jpeg format. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream, intrusive_ptr< Aspose::Cells::Systems::Drawing::Imaging::ImageFormat > imageFormat)=0
 Creates the chart image and saves it to a stream in the specified format. More...
 
virtual void ToPdf (intrusive_ptr< Aspose::Cells::Systems::String > fileName)=0
 Saves the chart to a pdf file. More...
 
virtual void ToPdf (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream)=0
 Creates the chart pdf and saves it to a stream. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::String > imageFile, intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions > options)=0
 Creates the chart image and saves it to a file. The extension of the file name determines the format of the image. More...
 
virtual void ToImage (intrusive_ptr< Aspose::Cells::Systems::IO::Stream > stream, intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions > options)=0
 Creates the chart image and saves it to a stream in the specified format. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::Drawing::Size > GetActualChartSize ()=0
 Gets actual size of chart More...
 
virtual Aspose::Cells::Drawing::PlacementType GetPlacement ()=0
 Represents the way the chart is attached to the cells below it. More...
 
virtual void SetPlacement (Aspose::Cells::Drawing::PlacementType value)=0
 Represents the way the chart is attached to the cells below it. More...
 
virtual intrusive_ptr< Aspose::Cells::IPageSetupGetIPageSetup ()=0
 Represents the page setup description in this chart. More...
 
virtual bool HasAxis (Aspose::Cells::Charts::AxisType aixsType, bool isPrimary)=0
 Returns which axes exist on the chart. More...
 
virtual void SetChartDataRange (intrusive_ptr< Aspose::Cells::Systems::String > area, bool isVertical)=0
 Specifies data range for a chart. More...
 
virtual intrusive_ptr< Aspose::Cells::Drawing::ILineGetILine ()=0
 Gets the line. More...
 

Detailed Description

Encapsulates the object that represents a single Excel chart.

[C++]
//Create a new Workbook.
intrusive_ptr<IWorkbook> workbook = Factory::CreateIWorkbook();
//Get the first worksheet in the workbook.
intrusive_ptr<IWorksheet> sheet = workbook->GetIWorksheets()->GetObjectByIndex(0);
intrusive_ptr<ICells> cells = sheet->GetICells();
cells->GetObjectByIndex(0, 1)->PutValue((StringPtr)(new String("Income")));
cells->GetObjectByIndex(1, 0)->PutValue((StringPtr)new String("Company A"));
cells->GetObjectByIndex(2, 0)->PutValue((StringPtr)new String("Company B"));
cells->GetObjectByIndex(3, 0)->PutValue((StringPtr)new String("Company C"));
cells->GetObjectByIndex(1, 1)->PutValue(10000);
cells->GetObjectByIndex(2, 1)->PutValue(20000);
cells->GetObjectByIndex(3, 1)->PutValue(30000);
int chartIndex = sheet->GetICharts()->Add(ChartType_Column, 9, 9, 21, 15);
intrusive_ptr<IChart> chart = sheet->GetICharts()->GetObjectByIndex(chartIndex);
chart->GetNISeries()->Add(new String("B2:B4"), true);
chart->GetNISeries()->SetCategoryData(new String("A2:A4"));
intrusive_ptr<ISeries> aSeries = chart->GetNISeries()->GetObjectByIndex(0);
chart->SetLegendShown( true);
chart->GetITitle()->SetText (new String("Income Analysis"));
workbook->Save(new String("D:\\test\\ChartTest.xls"));

Member Function Documentation

◆ Calculate()

virtual void Aspose::Cells::Charts::IChart::Calculate ( )
pure virtual

Calcuate the custom position of plot area, axises if the position of them are auto assigned.

◆ GetActualChartSize()

virtual intrusive_ptr<Aspose::Cells::Systems::Drawing::Size> Aspose::Cells::Charts::IChart::GetActualChartSize ( )
pure virtual

Gets actual size of chart

◆ GetAutoScaling()

virtual bool Aspose::Cells::Charts::IChart::GetAutoScaling ( )
pure virtual

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.

◆ GetBackIWall()

virtual intrusive_ptr<Aspose::Cells::Charts::IWalls> Aspose::Cells::Charts::IChart::GetBackIWall ( )
pure virtual

Returns a IWalls object that represents the back wall of a 3-D chart.

◆ GetCategoryIAxis()

virtual intrusive_ptr<Aspose::Cells::Charts::IAxis> Aspose::Cells::Charts::IChart::GetCategoryIAxis ( )
pure virtual

Gets the chart's X axis.

◆ GetDepthPercent()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetDepthPercent ( )
pure virtual

Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

◆ GetElevation()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetElevation ( )
pure virtual

Represents the elevation of the 3-D chart view, in degrees.

The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.

◆ GetFirstSliceAngle()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetFirstSliceAngle ( )
pure virtual

Gets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.

◆ GetGapDepth()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetGapDepth ( )
pure virtual

Gets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.

◆ GetGapWidth()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetGapWidth ( )
pure virtual

Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.

◆ GetHeightPercent()

virtual Aspose::Cells::Systems::Int16 Aspose::Cells::Charts::IChart::GetHeightPercent ( )
pure virtual

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

◆ GetHidePivotFieldButtons()

virtual bool Aspose::Cells::Charts::IChart::GetHidePivotFieldButtons ( )
pure virtual

Indicates whether hide the pivot chart field buttons only when the chart is PivotChart

◆ GetIChartArea()

virtual intrusive_ptr<Aspose::Cells::Charts::IChartArea> Aspose::Cells::Charts::IChart::GetIChartArea ( )
pure virtual

Gets the chart area in the worksheet

◆ GetIChartDataTable()

virtual intrusive_ptr<Aspose::Cells::Charts::IChartDataTable> Aspose::Cells::Charts::IChart::GetIChartDataTable ( )
pure virtual

Represents the chart data table.

◆ GetIChartObject()

virtual intrusive_ptr<Aspose::Cells::Drawing::IChartShape> Aspose::Cells::Charts::IChart::GetIChartObject ( )
pure virtual

Represents the chartShape;

◆ GetIChartPlotAreaWithoutTickLabels()

virtual intrusive_ptr<Aspose::Cells::Charts::IChartFrame> Aspose::Cells::Charts::IChart::GetIChartPlotAreaWithoutTickLabels ( )
pure virtual

Gets the chart's plot area which does not inculde axis tick lables.

◆ GetIFloor()

virtual intrusive_ptr<Aspose::Cells::Charts::IFloor> Aspose::Cells::Charts::IChart::GetIFloor ( )
pure virtual

Returns a IFloor object that represents the walls of a 3-D chart.

This property doesn't apply to 3-D pie charts.

◆ GetILegend()

virtual intrusive_ptr<Aspose::Cells::Charts::ILegend> Aspose::Cells::Charts::IChart::GetILegend ( )
pure virtual

Gets the chart legend.

◆ GetILine()

virtual intrusive_ptr<Aspose::Cells::Drawing::ILine> Aspose::Cells::Charts::IChart::GetILine ( )
pure virtual

Gets the line.

◆ GetIPageSetup()

virtual intrusive_ptr<Aspose::Cells::IPageSetup> Aspose::Cells::Charts::IChart::GetIPageSetup ( )
pure virtual

Represents the page setup description in this chart.

◆ GetIPivotOptions()

virtual intrusive_ptr<Aspose::Cells::Charts::IPivotOptions> Aspose::Cells::Charts::IChart::GetIPivotOptions ( )
pure virtual

Specifies the pivot controls that appear on the chart

◆ GetIPlotArea()

virtual intrusive_ptr<Aspose::Cells::Charts::IPlotArea> Aspose::Cells::Charts::IChart::GetIPlotArea ( )
pure virtual

Gets the chart's plot area which includes axis tick lables.

◆ GetIs3D()

virtual bool Aspose::Cells::Charts::IChart::GetIs3D ( )
pure virtual

Indicates whether the chart is a 3d chart.

◆ GetIShapes()

virtual intrusive_ptr<Aspose::Cells::Drawing::IShapeCollection> Aspose::Cells::Charts::IChart::GetIShapes ( )
pure virtual

Returns all drawing shapes in this chart.

◆ GetITitle()

virtual intrusive_ptr<Aspose::Cells::Charts::ITitle> Aspose::Cells::Charts::IChart::GetITitle ( )
pure virtual

Gets the chart's title.

◆ GetIWalls()

virtual intrusive_ptr<Aspose::Cells::Charts::IWalls> Aspose::Cells::Charts::IChart::GetIWalls ( )
pure virtual

Returns a IWalls object that represents the walls of a 3-D chart.

This property doesn't apply to 3-D pie charts.

◆ GetIWorksheet()

virtual intrusive_ptr<Aspose::Cells::IWorksheet> Aspose::Cells::Charts::IChart::GetIWorksheet ( )
pure virtual

Gets the worksheet which contains this chart.

◆ GetName()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Charts::IChart::GetName ( )
pure virtual

Gets the name of the chart.

◆ GetNISeries()

virtual intrusive_ptr<Aspose::Cells::Charts::ISeriesCollection> Aspose::Cells::Charts::IChart::GetNISeries ( )
pure virtual

Gets a ISeriesCollection collection representing the data series in the chart.

◆ GetPerspective()

virtual Aspose::Cells::Systems::Int16 Aspose::Cells::Charts::IChart::GetPerspective ( )
pure virtual

Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.

◆ GetPivotSource()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Charts::IChart::GetPivotSource ( )
pure virtual

The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.

If the pivot table "PivotTable1" in the Worksheet "Sheet1" in the file "Book1.xls". The pivotSource could be "[Book1.xls]Sheet1!PivotTable1" if the chart and the PivotTable is not in the same workbook. If you set this method ,the previous data source setting will be lost.

◆ GetPlacement()

virtual Aspose::Cells::Drawing::PlacementType Aspose::Cells::Charts::IChart::GetPlacement ( )
pure virtual

Represents the way the chart is attached to the cells below it.

◆ GetPlotEmptyCellsType()

virtual Aspose::Cells::Charts::PlotEmptyCellsType Aspose::Cells::Charts::IChart::GetPlotEmptyCellsType ( )
pure virtual

Gets how to plot the empty cells.

◆ GetPlotVisibleCells()

virtual bool Aspose::Cells::Charts::IChart::GetPlotVisibleCells ( )
pure virtual

Indicates whether only plot visible cells.

◆ GetPrintSize()

virtual Aspose::Cells::PrintSizeType Aspose::Cells::Charts::IChart::GetPrintSize ( )
pure virtual

Gets the printed chart size.

◆ GetRightAngleAxes()

virtual bool Aspose::Cells::Charts::IChart::GetRightAngleAxes ( )
pure virtual

True if the chart axes are at right angles.Applies only for 3-D charts(except Column3D and 3-D Pie Charts).

If this return True, the Perspective property is ignored.

◆ GetRotation()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetRotation ( )
pure virtual

Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

◆ GetRotationAngle()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetRotationAngle ( )
pure virtual

Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

◆ GetSecondCategoryIAxis()

virtual intrusive_ptr<Aspose::Cells::Charts::IAxis> Aspose::Cells::Charts::IChart::GetSecondCategoryIAxis ( )
pure virtual

Gets the chart's second X axis.

◆ GetSecondValueIAxis()

virtual intrusive_ptr<Aspose::Cells::Charts::IAxis> Aspose::Cells::Charts::IChart::GetSecondValueIAxis ( )
pure virtual

Gets the chart's second Y axis.

◆ GetSeriesIAxis()

virtual intrusive_ptr<Aspose::Cells::Charts::IAxis> Aspose::Cells::Charts::IChart::GetSeriesIAxis ( )
pure virtual

Gets the chart's series axis.

◆ GetShowDataTable()

virtual bool Aspose::Cells::Charts::IChart::GetShowDataTable ( )
pure virtual

Gets a value indicating whether the chart displays a data table.

◆ GetShowLegend()

virtual bool Aspose::Cells::Charts::IChart::GetShowLegend ( )
pure virtual

Gets a value indicating whether the chart legend will be displayed. Default is true.

◆ GetSideIWall()

virtual intrusive_ptr<Aspose::Cells::Charts::IWalls> Aspose::Cells::Charts::IChart::GetSideIWall ( )
pure virtual

Returns a IWalls object that represents the side wall of a 3-D chart.

◆ GetSizeWithWindow()

virtual bool Aspose::Cells::Charts::IChart::GetSizeWithWindow ( )
pure virtual

True if Microsoft Excel resizes the chart to match the size of the chart sheet window.

◆ GetStyle()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::IChart::GetStyle ( )
pure virtual

Gets the builtin style.

It should be between 1 and 48. Return -1 if it's not be set.

◆ GetType()

virtual Aspose::Cells::Charts::ChartType Aspose::Cells::Charts::IChart::GetType ( )
pure virtual

Gets a chart's type.

◆ GetValueIAxis()

virtual intrusive_ptr<Aspose::Cells::Charts::IAxis> Aspose::Cells::Charts::IChart::GetValueIAxis ( )
pure virtual

Gets the chart's Y axis.

◆ GetWallsAndGridlines2D()

virtual bool Aspose::Cells::Charts::IChart::GetWallsAndGridlines2D ( )
pure virtual

True if gridlines are drawn two-dimensionally on a 3-D chart.

◆ HasAxis()

virtual bool Aspose::Cells::Charts::IChart::HasAxis ( Aspose::Cells::Charts::AxisType  aixsType,
bool  isPrimary 
)
pure virtual

Returns which axes exist on the chart.

Normarlly, Pie, PieExploded, PiePie,PieBar, Pie3D, Pie3DExploded,Doughnut, DoughnutExploded is no axis.

◆ IsChartDataChanged()

virtual bool Aspose::Cells::Charts::IChart::IsChartDataChanged ( )
pure virtual

Detects if a chart's data source has changed.

The method detects the changes in the chart's data source before rendering the chart to image format. At first Chart.toImage call, the chart source data (e.g. XValuesParseData, ValuesParseData) will be recorded. Before calling the Chart.toImage method again, call IsChartDataChanged method to check if Chart needs re-rendering.

Returns
Returns true if the chart has changed otherwise returns false

◆ IsDataTableShown()

virtual bool Aspose::Cells::Charts::IChart::IsDataTableShown ( )
pure virtual

Gets a value indicating whether the chart displays a data table.

◆ IsLegendShown()

virtual bool Aspose::Cells::Charts::IChart::IsLegendShown ( )
pure virtual

Gets a value indicating whether the chart legend will be displayed. Default is true.

◆ IsRectangularCornered()

virtual bool Aspose::Cells::Charts::IChart::IsRectangularCornered ( )
pure virtual

Gets a value indicating whether the chart area is rectangular cornered. Default is true.

◆ Move()

virtual void Aspose::Cells::Charts::IChart::Move ( Aspose::Cells::Systems::Int32  upperLeftRow,
Aspose::Cells::Systems::Int32  upperLeftColumn,
Aspose::Cells::Systems::Int32  lowerRightRow,
Aspose::Cells::Systems::Int32  lowerRightColumn 
)
pure virtual

Moves the chart to a specified location.

Parameters
upperLeftColumnUpper left column index.
upperLeftRowUpper left row index.
lowerRightColumnLower right column index
lowerRightRowLower right row index

◆ RefreshPivotData()

virtual void Aspose::Cells::Charts::IChart::RefreshPivotData ( )
pure virtual

Refreshes pivot chart's data from it's pivot data source.

We will gather data from pivot data source to the pivot chart cache. This method is only used to gather all data to a pivot chart.

◆ SetAutoScaling()

virtual void Aspose::Cells::Charts::IChart::SetAutoScaling ( bool  value)
pure virtual

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True.

◆ SetChartDataRange()

virtual void Aspose::Cells::Charts::IChart::SetChartDataRange ( intrusive_ptr< Aspose::Cells::Systems::String >  area,
bool  isVertical 
)
pure virtual

Specifies data range for a chart.

Parameters
areaSpecifies values from which to plot the data series
isVerticalSpecifies whether to plot the series from a range of cell values by row or by column.

◆ SetDataTableShown()

virtual void Aspose::Cells::Charts::IChart::SetDataTableShown ( bool  value)
pure virtual

Sets a value indicating whether the chart displays a data table.

◆ SetDepthPercent()

virtual void Aspose::Cells::Charts::IChart::SetDepthPercent ( Aspose::Cells::Systems::Int32  value)
pure virtual

Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

◆ SetElevation()

virtual void Aspose::Cells::Charts::IChart::SetElevation ( Aspose::Cells::Systems::Int32  value)
pure virtual

Represents the elevation of the 3-D chart view, in degrees.

The chart elevation is the height at which you view the chart, in degrees. The default is 15 for most chart types. The value of this property must be between -90 and 90, except for 3-D bar charts, where it must be between 0 and 44.

◆ SetFirstSliceAngle()

virtual void Aspose::Cells::Charts::IChart::SetFirstSliceAngle ( Aspose::Cells::Systems::Int32  value)
pure virtual

Gets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.

◆ SetGapDepth()

virtual void Aspose::Cells::Charts::IChart::SetGapDepth ( Aspose::Cells::Systems::Int32  value)
pure virtual

Sets the distance between the data series in a 3-D chart, as a percentage of the marker width. The value of this property must be between 0 and 500.

◆ SetGapWidth()

virtual void Aspose::Cells::Charts::IChart::SetGapWidth ( Aspose::Cells::Systems::Int32  value)
pure virtual

Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500.

◆ SetHeightPercent()

virtual void Aspose::Cells::Charts::IChart::SetHeightPercent ( Aspose::Cells::Systems::Int16  value)
pure virtual

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

◆ SetHidePivotFieldButtons()

virtual void Aspose::Cells::Charts::IChart::SetHidePivotFieldButtons ( bool  value)
pure virtual

Indicates whether hide the pivot chart field buttons only when the chart is PivotChart

◆ SetLegendShown()

virtual void Aspose::Cells::Charts::IChart::SetLegendShown ( bool  value)
pure virtual

Sets a value indicating whether the chart legend will be displayed. Default is true.

>

◆ SetName()

virtual void Aspose::Cells::Charts::IChart::SetName ( intrusive_ptr< Aspose::Cells::Systems::String >  value)
pure virtual

Sets the name of the chart.

◆ SetPerspective()

virtual void Aspose::Cells::Charts::IChart::SetPerspective ( Aspose::Cells::Systems::Int16  value)
pure virtual

Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100. This property is ignored if the RightAngleAxes property is True.

◆ SetPivotSource()

virtual void Aspose::Cells::Charts::IChart::SetPivotSource ( intrusive_ptr< Aspose::Cells::Systems::String >  value)
pure virtual

The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.

If the pivot table "PivotTable1" in the Worksheet "Sheet1" in the file "Book1.xls". The pivotSource could be "[Book1.xls]Sheet1!PivotTable1" if the chart and the PivotTable is not in the same workbook. If you set this property ,the previous data source setting will be lost.

◆ SetPlacement()

virtual void Aspose::Cells::Charts::IChart::SetPlacement ( Aspose::Cells::Drawing::PlacementType  value)
pure virtual

Represents the way the chart is attached to the cells below it.

◆ SetPlotEmptyCellsType()

virtual void Aspose::Cells::Charts::IChart::SetPlotEmptyCellsType ( Aspose::Cells::Charts::PlotEmptyCellsType  value)
pure virtual

Sets how to plot the empty cells.

◆ SetPlotVisibleCells()

virtual void Aspose::Cells::Charts::IChart::SetPlotVisibleCells ( bool  value)
pure virtual

Indicates whether only plot visible cells.

◆ SetPrintSize()

virtual void Aspose::Cells::Charts::IChart::SetPrintSize ( Aspose::Cells::PrintSizeType  value)
pure virtual

Sets the printed chart size.

◆ SetRectangularCornered()

virtual void Aspose::Cells::Charts::IChart::SetRectangularCornered ( bool  value)
pure virtual

Sets a value indicating whether the chart area is rectangular cornered. Default is true.

◆ SetRightAngleAxes()

virtual void Aspose::Cells::Charts::IChart::SetRightAngleAxes ( bool  value)
pure virtual

True if the chart axes are at right angles.Applies only for 3-D charts(except Column3D and 3-D Pie Charts).

If this return True, the Perspective property is ignored.

◆ SetRotation()

virtual void Aspose::Cells::Charts::IChart::SetRotation ( Aspose::Cells::Systems::Int32  value)
pure virtual

Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

◆ SetRotationAngle()

virtual void Aspose::Cells::Charts::IChart::SetRotationAngle ( Aspose::Cells::Systems::Int32  value)
pure virtual

Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.

◆ SetShowDataTable()

virtual void Aspose::Cells::Charts::IChart::SetShowDataTable ( bool  value)
pure virtual

Sets a value indicating whether the chart displays a data table.

◆ SetShowLegend()

virtual void Aspose::Cells::Charts::IChart::SetShowLegend ( bool  value)
pure virtual

Sets a value indicating whether the chart legend will be displayed. Default is true.

◆ SetSizeWithWindow()

virtual void Aspose::Cells::Charts::IChart::SetSizeWithWindow ( bool  value)
pure virtual

True if Microsoft Excel resizes the chart to match the size of the chart sheet window.

◆ SetStyle()

virtual void Aspose::Cells::Charts::IChart::SetStyle ( Aspose::Cells::Systems::Int32  value)
pure virtual

Sets the builtin style.

◆ SetType()

virtual void Aspose::Cells::Charts::IChart::SetType ( Aspose::Cells::Charts::ChartType  value)
pure virtual

Sets a chart's type.

◆ SetWallsAndGridlines2D()

virtual void Aspose::Cells::Charts::IChart::SetWallsAndGridlines2D ( bool  value)
pure virtual

True if gridlines are drawn two-dimensionally on a 3-D chart.

◆ ToImage() [1/9]

virtual intrusive_ptr<Aspose::Cells::Systems::Drawing::Bitmap> Aspose::Cells::Charts::IChart::ToImage ( )
pure virtual

Gets a 32-bit Bitmap object of the chart.

Returns
the picture of the chart.

◆ ToImage() [2/9]

virtual intrusive_ptr<Aspose::Cells::Systems::Drawing::Bitmap> Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions options)
pure virtual

Gets a 32-bit Bitmap object of the chart. ImageOrPrintOptions.ImageFormat , ImageOrPrintOptions.TiffCompression and ImageOrPrintOptions.Quality attributes are ignored.

Parameters
optionsAddtional image creation options
Returns
the picture of the chart.

Returns a 32-bit bitmap object, so ImageOrPrintOptions.ImageFormat, ImageOrPrintOptions.TiffCompression and ImageOrPrintOptions.Quality attributes do not affect the method.

If the width or height is zero or the chart is not supported according to Supported Charts List, it will return null.

Gets a bitmap object with 200 x dpi and 300 y dpi.

[C++]
intrusive_ptr<IImageOrPrintOptions> options = Factory::CreateIImageOrPrintOptions();
options->SetHorizontalResolution(200);
options->SetVerticalResolution(300);
intrusive_ptr<IWorkbook> wb = Factory::CreateIWorkbook(new String("c:\test.xls"));
intrusive_ptr<Aspose::Cells::Systems::Drawing::Bitmap> chartObject = wb->GetIWorksheets()->GetObjectByIndex(0)->GetICharts()->GetObjectByIndex(0)->ToImage(options);

◆ ToImage() [3/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::String >  imageFile)
pure virtual

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

Parameters
imageFileThe image file name with full path.

The format of the image is specified by using the extension of the file name. For example, if you specify "myfile.png", then the image will be saved in the PNG format. The following file extensions are recognized: .bmp, .gif, .png, .jpg, .jpeg, .tiff, .tif, .emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToImage() [4/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::String >  imageFile,
intrusive_ptr< Aspose::Cells::Systems::Drawing::Imaging::ImageFormat >  imageFormat 
)
pure virtual

Creates the chart image and saves it to a file in the specified format.

Parameters
imageFileThe image file name with full path.
imageFormatThe format in which to save the image.

The format of the image is specified by using imageFormatThe following formats are supported: ImageFormat.Bmp, ImageFormat.Gif, ImageFormat.Png, ImageFormat.Jpeg, ImageFormat.Tiff, ImageFormat.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToImage() [5/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::String >  imageFile,
Aspose::Cells::Systems::Int64  jpegQuality 
)
pure virtual

Creates the chart image and saves it to a file in the Jpeg format.

Parameters
imageFileThe image file name with full path.
jpegQualityJpeg quality.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToImage() [6/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream,
Aspose::Cells::Systems::Int64  jpegQuality 
)
pure virtual

Creates the chart image and saves it to a stream in the Jpeg format.

Parameters
streamThe output stream.
jpegQualityJpeg quality.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToImage() [7/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream,
intrusive_ptr< Aspose::Cells::Systems::Drawing::Imaging::ImageFormat >  imageFormat 
)
pure virtual

Creates the chart image and saves it to a stream in the specified format.

Parameters
streamThe output stream.
imageFormatThe format in which to save the image.

The format of the image is specified by using imageFormatThe following formats are supported: ImageFormat.Bmp, ImageFormat.Gif, ImageFormat.Png, ImageFormat.Jpeg, ImageFormat.Tiff, ImageFormat.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToImage() [8/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::String >  imageFile,
intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions options 
)
pure virtual

Creates the chart image and saves it to a file. The extension of the file name determines the format of the image.

Parameters
imageFileThe image file name with full path.
optionsAddtional image creation options

The format of the image is specified by using the extension of the file name. For example, if you specify "myfile.png", then the image will be saved in the PNG format. The following file extensions are recognized: .bmp, .gif, .png, .jpg, .jpeg, .tiff, .tif, .emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing. Please refer to Supported Charts List for more details.

Saves to Tiff with 300 dpi and CCITT4 compression.

[C++]
intrusive_ptr<IImageOrPrintOptions> options = Factory::CreateIImageOrPrintOptions();
options->SetHorizontalResolution(300);
options->SetVerticalResolution(300);
options->SetTiffCompression(TiffCompression_CompressionCCITT4);
intrusive_ptr<IWorkbook> book = Factory::CreateIWorkbook(new String("D:\test.xls"));
book->GetIWorksheets()->GetObjectByIndex(0)->GetICharts()->GetObjectByIndex(0)->ToImage(new String("D:\chart.Tiff"), options);

◆ ToImage() [9/9]

virtual void Aspose::Cells::Charts::IChart::ToImage ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream,
intrusive_ptr< Aspose::Cells::Rendering::IImageOrPrintOptions options 
)
pure virtual

Creates the chart image and saves it to a stream in the specified format.

Parameters
streamThe output stream.
optionsAddtional image creation options

The format of the image is specified by using options.ImageFormatThe following formats are supported: ImageFormat.Bmp, ImageFormat.Gif, ImageFormat.Png, ImageFormat.Jpeg, ImageFormat.Tiff, ImageFormat.Emf.

If the width or height is zero or the chart is not supported according to Supported Charts List, this method will do nothing.

◆ ToPdf() [1/2]

virtual void Aspose::Cells::Charts::IChart::ToPdf ( intrusive_ptr< Aspose::Cells::Systems::String >  fileName)
pure virtual

Saves the chart to a pdf file.

Parameters
fileNamethe pdf file name with full path

◆ ToPdf() [2/2]

virtual void Aspose::Cells::Charts::IChart::ToPdf ( intrusive_ptr< Aspose::Cells::Systems::IO::Stream >  stream)
pure virtual

Creates the chart pdf and saves it to a stream.

Parameters
streamThe output stream.