Chart Formatting

Format Chart Entities

Aspose.Slides for C++ lets developers add custom charts to their slides from scratch. This article explains how to format different chart entities including chart category and value axis.

Aspose.Slides for C++ provides a simple API for managing different chart entities and formatting them using custom values:

1. Create an instance of the Presentation class.
2. Obtain a slide’s reference by its index.
3. Add a chart with default data along with the any of the desired type (in this example we will use ChartType.LineWithMarkers).
4. Access the chart Value Axis and set the following properties:
   1. Setting Line format for Value Axis Major Grid lines
   2. Setting Line format for Value Axis Minor Grid lines
   3. Setting Number Format for Value Axis
   4. Setting Min, Max, Major and Minor units for Value Axis
   5. Setting Text Properties for Value Axis data
   6. Setting Title for Value Axis
   7. Setting Line Format for Value Axis
5. Access the chart Category Axis and set the following properties:
   1. Setting Line format for Category Axis Major Grid lines
   2. Setting Line format for Category Axis Minor Grid lines
   3. Setting Text Properties for Category Axis data
   4. Setting Title for Category Axis
   5. Setting Label Positioning for Category Axis
   6. Setting Rotation Angle for Category Axis labels
6. Access the chart Legend and set the Text Properties for them
7. Set show chart Legends without overlapping chart
8. Access the chart Secondary Value Axis and set the following properties:
   1. Enable the Secondary Value Axis
   2. Setting Line Format for Secondary Value Axis
   3. Setting Number Format for Secondary Value Axis
   4. Setting Min, Max, Major and Minor units for Secondary Value Axis
9. Now plot the first chart series on Secondary Value Axis
10. Set the chart back wall to fill color
11. Set the chart plot area fill color
12. Write the modified presentation to a PPTX file

For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Slides-for-C

	// The path to the documents directory.
	const String outPath = u"../out/FormatChart_out.pptx";

	//Instantiate Presentation class that represents PPTX file
	SharedPtr<Presentation> pres = MakeObject<Presentation>();

	//Access first slide
	SharedPtr<ISlide> slide = pres->get_Slides()->idx_get(0);

	// Add chart with default data
	SharedPtr<IChart> chart = slide->get_Shapes()->AddChart(Aspose::Slides::Charts::ChartType::LineWithMarkers, 0, 0, 500, 500);


	// Setting Chart Titile
	chart->set_HasTitle(true);
	chart->get_ChartTitle()->AddTextFrameForOverriding(u"");
	SharedPtr<IPortion> chartTitle = chart->get_ChartTitle()->get_TextFrameForOverriding()->get_Paragraphs()->idx_get(0)->get_Portions()->idx_get(0);
	chartTitle->set_Text(u"Sample Chart");
	chartTitle->get_PortionFormat()->get_FillFormat()->set_FillType  (FillType::Solid);
	chartTitle->get_PortionFormat()->get_FillFormat()->get_SolidFillColor()->set_Color (System::Drawing::Color::get_Gray());
	chartTitle->get_PortionFormat()->set_FontHeight ( 20);
	chartTitle->get_PortionFormat()->set_FontBold ( NullableBool::True);
	chartTitle->get_PortionFormat()->set_FontItalic ( NullableBool::True);

	// Setting Major grid lines format for value axis
	chart->get_Axes()->get_VerticalAxis()->get_MajorGridLinesFormat()->get_Line()->get_FillFormat()->set_FillType (FillType::Solid);
	chart->get_Axes()->get_VerticalAxis()->get_MajorGridLinesFormat()->get_Line()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Blue());
	chart->get_Axes()->get_VerticalAxis()->get_MajorGridLinesFormat()->get_Line()->set_Width ( 5);
	chart->get_Axes()->get_VerticalAxis()->get_MajorGridLinesFormat()->get_Line()->set_DashStyle (LineDashStyle::DashDot);

	// Setting Minor grid lines format for value axis
	chart->get_Axes()->get_VerticalAxis()->get_MinorGridLinesFormat()->get_Line()->get_FillFormat()->set_FillType(Aspose::Slides::FillType::Solid);
	chart->get_Axes()->get_VerticalAxis()->get_MinorGridLinesFormat()->get_Line()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Red());
	chart->get_Axes()->get_VerticalAxis()->get_MinorGridLinesFormat()->get_Line()->set_Width(3);

	// Setting value axis number format
	chart->get_Axes()->get_VerticalAxis()->set_IsNumberFormatLinkedToSource ( false);
	chart->get_Axes()->get_VerticalAxis()->set_DisplayUnit ( DisplayUnitType::Thousands);
	chart->get_Axes()->get_VerticalAxis()->set_NumberFormat(u"0.0%");

	// Setting chart maximum, minimum values
	chart->get_Axes()->get_VerticalAxis()->set_IsAutomaticMajorUnit(false);
	chart->get_Axes()->get_VerticalAxis()->set_IsAutomaticMaxValue(false);
	chart->get_Axes()->get_VerticalAxis()->set_IsAutomaticMinorUnit(false);
	chart->get_Axes()->get_VerticalAxis()->set_IsAutomaticMinValue(false);

	chart->get_Axes()->get_VerticalAxis()->set_MaxValue (15);
	chart->get_Axes()->get_VerticalAxis()->set_MinValue ( -2);
	chart->get_Axes()->get_VerticalAxis()->set_MinorUnit ( 0.5);
	chart->get_Axes()->get_VerticalAxis()->set_MajorUnit ( 2.0);

	// Setting Value Axis Text Properties
	SharedPtr<IChartPortionFormat> txtVal = chart->get_Axes()->get_VerticalAxis()->get_TextFormat()->get_PortionFormat();
	txtVal->set_FontBold ( NullableBool::True);
	txtVal->set_FontHeight( 16);
	txtVal->set_FontItalic ( NullableBool::True);
	txtVal->get_FillFormat()->set_FillType ( FillType::Solid) ;
	txtVal->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing:: Color::get_DarkGreen());
	SharedPtr<FontData> fontData = MakeObject<FontData>(u"Times New Roman");

	//FontDataFactory.CreateFontData	//txtVal->set_LatinFont(MakeObject<IFontData>(u"Times New Roman"));
	txtVal->set_LatinFont(fontData);

	// Setting value axis title
	chart->get_Axes()->get_VerticalAxis()->set_HasTitle(true);
	chart->get_Axes()->get_VerticalAxis()->get_Title()->AddTextFrameForOverriding(u"");
	SharedPtr<IPortion> valtitle = chart->get_Axes()->get_VerticalAxis()->get_Title()->get_TextFrameForOverriding()->get_Paragraphs()->idx_get(0)->get_Portions()->idx_get(0);
	valtitle->set_Text(u"Primary Axis");
	valtitle->get_PortionFormat()->get_FillFormat()->set_FillType( FillType::Solid);
	valtitle->get_PortionFormat()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Gray());
	valtitle->get_PortionFormat()->set_FontHeight ( 20);
	valtitle->get_PortionFormat()->set_FontBold (NullableBool::True);
	valtitle->get_PortionFormat()->set_FontItalic ( NullableBool::True);

	
	// Setting Major grid lines format for Category axis
	chart->get_Axes()->get_HorizontalAxis()->get_MajorGridLinesFormat()->get_Line()->get_FillFormat()->set_FillType ( FillType::Solid);
	chart->get_Axes()->get_HorizontalAxis()->get_MajorGridLinesFormat()->get_Line()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Green());
	chart->get_Axes()->get_HorizontalAxis()->get_MajorGridLinesFormat()->get_Line()->set_Width( 5);

	// Setting Minor grid lines format for Category axis
	chart->get_Axes()->get_HorizontalAxis()->get_MinorGridLinesFormat()->get_Line()->get_FillFormat()->set_FillType(FillType::Solid);
	chart->get_Axes()->get_HorizontalAxis()->get_MinorGridLinesFormat()->get_Line()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Yellow());
	chart->get_Axes()->get_HorizontalAxis()->get_MinorGridLinesFormat()->get_Line()->set_Width(3);

	// Setting Category Axis Text Properties
	SharedPtr<IChartPortionFormat> txtCat = chart->get_Axes()->get_HorizontalAxis()->get_TextFormat()->get_PortionFormat();
	txtCat->set_FontBold (NullableBool::True);
	txtCat->set_FontHeight ( 16);
	txtCat->set_FontItalic ( NullableBool::True);
	txtCat->get_FillFormat()->set_FillType( FillType::Solid) ;
	txtCat->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Blue());
	SharedPtr<FontData> Arial = MakeObject<FontData>(u"Arial");

	txtCat->set_LatinFont(Arial);

	// Setting Category Titile
	chart->get_Axes()->get_HorizontalAxis()->set_HasTitle ( true);
	chart->get_Axes()->get_HorizontalAxis()->get_Title()->AddTextFrameForOverriding(u"");

	SharedPtr<IPortion> catTitle = chart->get_Axes()->get_HorizontalAxis()->get_Title()->get_TextFrameForOverriding()->get_Paragraphs()->idx_get(0)->get_Portions()->idx_get(0);
	catTitle->set_Text(u"Sample Category");
	catTitle->get_PortionFormat()->get_FillFormat()->set_FillType(FillType::Solid);
	catTitle->get_PortionFormat()->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Gray());
	catTitle->get_PortionFormat()->set_FontHeight( 20);
	catTitle->get_PortionFormat()->set_FontBold (NullableBool::True);
	catTitle->get_PortionFormat()->set_FontItalic ( NullableBool::True);

	// Setting category axis lable position
	chart->get_Axes()->get_HorizontalAxis()->set_TickLabelPosition( TickLabelPositionType::Low);

	// Setting category axis lable rotation angle
	chart->get_Axes()->get_HorizontalAxis()->set_TickLabelRotationAngle ( 45);

	// Setting Legends Text Properties
	SharedPtr<IChartPortionFormat> txtleg = chart->get_Legend()->get_TextFormat()->get_PortionFormat();
	txtleg->set_FontBold ( NullableBool::True);
	txtleg->set_FontHeight ( 16);
	txtleg->set_FontItalic (NullableBool::True);
	txtleg->get_FillFormat()->set_FillType (FillType::Solid) ;
	txtleg->get_FillFormat()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_DarkRed());

	// Set show chart legends without overlapping chart

	chart->get_Legend()->set_Overlay( true);

	// Ploting first series on secondary value axis
	// Chart.ChartData.Series[0].PlotOnSecondAxis = true;

	// Setting chart back wall color
	chart->get_BackWall()->set_Thickness( 1);
	chart->get_BackWall()->get_Format()->get_Fill()->set_FillType( FillType::Solid);
	chart->get_BackWall()->get_Format()->get_Fill()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Orange());

	chart->get_Floor()->get_Format()->get_Fill()->set_FillType(FillType::Solid);
	chart->get_Floor()->get_Format()->get_Fill()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_Red());
	// Setting Plot area color
	chart->get_PlotArea()->get_Format()->get_Fill()->set_FillType(FillType::Solid);
	chart->get_PlotArea()->get_Format()->get_Fill()->get_SolidFillColor()->set_Color(System::Drawing::Color::get_LightCyan());


	// Write the presentation file to disk
	pres->Save(outPath, Aspose::Slides::Export::SaveFormat::Pptx);

Set Font Properties for Chart

Aspose.Slides for C++ provides support for setting the font related properties for the chart. Please follow the steps below for setting the font properties for chart.

• Instantiate Presentation class object.
• Add chart on the slide.
• Set font height.
• Save modified presentation.

Below sample example is given.

// The path to the documents directory.
const String outPath = u"../out/FontPropertiesForChart.pptx";

//Instantiate Presentation class that represents PPTX file
SharedPtr<Presentation> pres = MakeObject<Presentation>();

SharedPtr<IChart> chart = pres->get_Slides()->idx_get(0)->get_Shapes()->AddChart(Aspose::Slides::Charts::ChartType::ClusteredColumn, 100, 100, 500, 400);
chart->get_TextFormat()->get_PortionFormat()->set_FontHeight(20);
chart->get_ChartData()->get_Series()->idx_get(0)->get_Labels()->get_DefaultDataLabelFormat()->set_ShowValue(true);
pres->Save(outPath, Aspose::Slides::Export::SaveFormat::Pptx);

Set Font Properties for Chart Data Table

Aspose.Slides for C++ provides support for changing color of categories in a series color.

1. Instantiate Presentation class object.
2. Add chart on the slide.
3. set chart table.
4. Set font height.
5. Save modified presentation.

Below sample example is given.

For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Slides-for-C

	// The path to the documents directory.
	const String outPath = u"../out/SettingFontPropertiesForChartDataTable_out.pptx";

	//Instantiate Presentation class that represents PPTX file
	SharedPtr<Presentation> pres = MakeObject<Presentation>();

	//Access first slide
	SharedPtr<ISlide> slide = pres->get_Slides()->idx_get(0);

	// Add chart with default data
	SharedPtr<IChart> chart = slide->get_Shapes()->AddChart(Aspose::Slides::Charts::ChartType::ClusteredColumn, 0, 0, 500, 500);
	
	//Setting chart data table
	chart->set_HasDataTable(true);

	//Setting font properties
	chart->get_ChartDataTable()->get_TextFormat()->get_PortionFormat()->set_FontBold (NullableBool::True);
	chart->get_ChartDataTable()->get_TextFormat()->get_PortionFormat()->set_FontHeight ( 20);

	// Write the presentation file to disk
	pres->Save(outPath, Aspose::Slides::Export::SaveFormat::Pptx);

Set Chart Area Rounded Borders

Aspose.Slides for C++ provides support for setting chart area. IChart.HasRoundedCorners and Chart.HasRoundedCorners properties have been added in Aspose.Slides.

1. Instantiate Presentation class object.
2. Add chart on the slide.
3. Set fill type and fill color of chart
4. Set round corner property True.
5. Save modified presentation.

Below sample example is given.

For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Slides-for-C

	// The path to the documents directory.
	const String outPath = u"../out/SettingChartAreaRoundedBorders_out.pptx";

	//Instantiate Presentation class that represents PPTX file
	SharedPtr<Presentation> pres = MakeObject<Presentation>();

	//Access first slide
	SharedPtr<ISlide> slide = pres->get_Slides()->idx_get(0);

	// Add chart with default data
	SharedPtr<IChart> chart = slide->get_Shapes()->AddChart(Aspose::Slides::Charts::ChartType::ClusteredColumn, 0, 0, 500, 500);

	chart->get_LineFormat()->get_FillFormat()->set_FillType(FillType::Solid);
	chart->get_LineFormat()->set_Style(LineStyle::Single);
	chart->set_HasRoundedCorners ( true);

	// Write the presentation file to disk
	pres->Save(outPath, Aspose::Slides::Export::SaveFormat::Pptx);

Set Chart Data Numbers

Aspose.Slides for C++ provides a simple API for managing chart data format:

1. Create an instance of the Presentation class.
2. Obtain a slide’s reference by its index.
3. Add a chart with default data along with the any of desired type (this example uses ChartType.ClusteredColumn).
4. Set the preset number format from the possible preset values.
5. Traverse through the chart data cell in every chart series and set the chart data number format.
6. Save the presentation.
7. Set the custom number format.
8. Traverse through chart data cell inside every chart series and setting a different chart data number format.
9. Save the presentation.

For complete examples and data files, please go to https://github.com/aspose-slides/Aspose.Slides-for-C

	// The path to the documents directory.
	const String outPath = u"../out/NumberFormat_out.pptx";

	//Instantiate Presentation class that represents PPTX file
	SharedPtr<Presentation> pres = MakeObject<Presentation>();

	//Access first slide
	SharedPtr<ISlide> slide = pres->get_Slides()->idx_get(0);

	// Add chart with default data
	SharedPtr<IChart> chart = slide->get_Shapes()->AddChart(Aspose::Slides::Charts::ChartType::ClusteredColumn, 0, 0, 500, 500);


	// Accessing the chart series collection
	SharedPtr<IChartSeriesCollection> seriesCollection = chart->get_ChartData()->get_Series();

	// Setting the preset number format
	// Traverse through every chart series
	for(int i = 0; i < seriesCollection->get_Count();i++)
	{
		auto series = seriesCollection->idx_get(i);
		// Traverse through every data cell in series
		for(int j=0;j<series->get_DataPoints()->get_Count();j++)
		{
			auto cell = series->get_DataPoints()->idx_get(j);
			// Setting the number format
			cell->get_Value()->get_AsCell()->set_PresetNumberFormat (10); //0.00%
		}
	}

	// Write the presentation file to disk
	pres->Save(outPath, Aspose::Slides::Export::SaveFormat::Pptx);

	The possible preset number format values along with their preset index and that can be used are given below:

0	General
1	0
2	0.00
3	#,##0
4	#,##0.00
5	$#,##0;$-#,##0
6	$#,##0;Red$-#,##0
7	$#,##0.00;$-#,##0.00
8	$#,##0.00;Red$-#,##0.00
9	0%
10	0.00%
11	0.00E+00
12	# ?/?
13	# /
14	m/d/yy
15	d-mmm-yy
16	d-mmm
17	mmm-yy
18	h:mm AM/PM
19	h:mm:ss AM/PM
20	h:mm
21	h:mm:ss
22	m/d/yy h:mm
37	#,##0;-#,##0
38	#,##0;Red-#,##0
39	#,##0.00;-#,##0.00
40	#,##0.00;Red-#,##0.00
41	_ * #,##0_ ;_ * “_ ;_ @_
42	_ $* #,##0_ ;_ $* “_ ;_ @_
43	_ * #,##0.00_ ;_ * “??_ ;_ @_
44	_ $* #,##0.00_ ;_ $* “??_ ;_ @_
45	mm:ss
46	h :mm:ss
47	mm:ss.0
48	##0.0E+00
49	@