Create a Column Chart

Introduction

The example below shows how to create an ordinary column chart using Aspose.Slides Cloud. A chart is a kind of shape, so you should use CreateShape method for this action.

cURL Example

Request

Create Authentication Headers


curl -v "https://api.aspose.cloud/connect/token" -X POST -d "grant_type=client_credentials&client_id=XXXX&client_secret=XXXX-XX" -H "Content-Type: application/x-www-form-urlencoded" -H "Accept: application/json"


curl  -v "https://api.aspose.cloud/v3.0/slides/MyPresentation.pptx/slides/1/shapes" -d @"chart.json" -H "Content-Type: text/json" -H "Authorization: Bearer [Access Token]

chart.json file:

{
    "type": "Chart",
    "chartType": "ClusteredColumn",
    "x": 100,
    "y": 100,
    "width": 400,
    "height": 400,
    "title": { "text": "Column Chart" },
    "categories": [
        { "Value": "Category1" },
        { "Value": "Category2" },
        { "Value": "Category3" }
    ],
    "series": [
        {
            "dataPointType": "OneValue",
            "dataPoints": [
                { "value": 20 },
                { "value": 50 },
                { "value": 30 }
            ]
        },
        {
            "dataPointType": "OneValue",
            "dataPoints": [
                { "value": 30 },
                { "value": 10 },
                { "value": 60 }
            ]
        }
    ]              
}

Response

{
    "type": "Chart",
    "chartType": "ClusteredColumn",
    "showDataLabelsOverMaximum": true,
    "series": [
        {
            "dataPointType": "OneValue",
            "dataPoints": [
                { "value": 20.0 },
                { "value": 50.0 },
                { "value": 30.0 }
            ],
            "name": "Column02",
            "order": 0,
            "invertIfNegative": true
        },
        {
            "dataPointType": "OneValue",
            "dataPoints": [
                { "value": 30.0 },
                { "value": 10.0 },
                { "value": 60.0 }
            ],
            "name": "Column03",
            "order": 1,
            "invertIfNegative": true
        }
    ],
    "categories": [
        { "value": "Category1" },
        { "value": "Category2" },
        { "value": "Category3" }
    ],
    "hasTitle": true,
    "title": { "text": "Column Chart" },
    "name": "ChartObject",
    "width": 400.0,
    "height": 400.0,
    "x": 100.0,
    "y":100.0,
    "lineFormat": {
        "alignment": "Center",
        "capStyle": "Flat",
        "dashStyle": "Solid",
        "joinStyle": "Round",
        "style": "Single",
        "miterLimit": 10.0,
        "width": 0.75
    },
    "selfUri": {
        "href": "https://api.aspose.cloud/v3.0/slides/MyPresentation.pptx/slides/1/shapes/2",
        "relation": "self"
    }
}

SDK Source

The Aspose for Cloud SDKs can be downloaded from the following page: Available SDKs

SDK Examples

SlidesApi api = new SlidesApi("MyClientId", "MyClientSecret");
Chart dto = new Chart();
dto.ChartType = Chart.ChartTypeEnum.ClusteredColumn;
dto.X = 100;
dto.Y = 100;
dto.Width = 400;
dto.Height = 400;
dto.Title = new ChartTitle { Text = "Column Chart" };

dto.Categories = new System.Collections.Generic.List<ChartCategory>();
dto.Categories.Add(new ChartCategory { Value = "Category1" });
dto.Categories.Add(new ChartCategory { Value = "Category2" });
dto.Categories.Add(new ChartCategory { Value = "Category3" });

dto.Series = new System.Collections.Generic.List<Series>();
OneValueSeries series1 = new OneValueSeries();
series1.DataPoints = new System.Collections.Generic.List<OneValueChartDataPoint>();
series1.DataPoints.Add(new OneValueChartDataPoint { Value = 20 });
series1.DataPoints.Add(new OneValueChartDataPoint { Value = 50 });
series1.DataPoints.Add(new OneValueChartDataPoint { Value = 30 });
dto.Series.Add(series1);

OneValueSeries series2 = new OneValueSeries();
series2.DataPoints = new System.Collections.Generic.List<OneValueChartDataPoint>();
series2.DataPoints.Add(new OneValueChartDataPoint { Value = 30 });
series2.DataPoints.Add(new OneValueChartDataPoint { Value = 10 });
series2.DataPoints.Add(new OneValueChartDataPoint { Value = 60 });
dto.Series.Add(series2);

Chart chart = (Chart)api.CreateShape("MyPresentation.pptx", 1, dto);
Console.WriteLine(chart.Categories.Count);

Java

SlidesApi api = new SlidesApi("MyClientId", "MyClientSecret");
Chart dto = new Chart();
dto.setChartType(Chart.ChartTypeEnum.CLUSTEREDCOLUMN);
dto.setX(100.0);
dto.setY(100.0);
dto.setWidth(400.0);
dto.setHeight(400.0);

ChartTitle title = new ChartTitle();
title.setText("Column Chart");
dto.setTitle(title);

List<ChartCategory> categories = new ArrayList<ChartCategory>();
ChartCategory category1 = new ChartCategory();
category1.setValue("Category1");
categories.add(category1);
ChartCategory category2 = new ChartCategory();
category2.setValue("Category2");
categories.add(category2);
ChartCategory category3 = new ChartCategory();
category3.setValue("Category3");
categories.add(category3);
dto.setCategories(categories);

List<Series> seriesList = new ArrayList<Series>();
OneValueSeries series1 = new OneValueSeries();
List<OneValueChartDataPoint> dataPoints1 = new ArrayList<OneValueChartDataPoint>();
OneValueChartDataPoint dataPoint11 = new OneValueChartDataPoint();
dataPoint11.setValue(20.0);
dataPoints1.add(dataPoint11);

OneValueChartDataPoint dataPoint12 = new OneValueChartDataPoint();
dataPoint12.setValue(50.0);
dataPoints1.add(dataPoint12);

OneValueChartDataPoint dataPoint13 = new OneValueChartDataPoint();
dataPoint13.setValue(30.0);
dataPoints1.add(dataPoint13);
series1.setDataPoints(dataPoints1);
seriesList.add(series1);

OneValueSeries series2 = new OneValueSeries();
List<OneValueChartDataPoint> dataPoints2 = new ArrayList<OneValueChartDataPoint>();
OneValueChartDataPoint dataPoint21 = new OneValueChartDataPoint();
dataPoint21.setValue(30.0);
dataPoints2.add(dataPoint21);

OneValueChartDataPoint dataPoint22 = new OneValueChartDataPoint();
dataPoint22.setValue(10.0);
dataPoints2.add(dataPoint22);

OneValueChartDataPoint dataPoint23 = new OneValueChartDataPoint();
dataPoint23.setValue(60.0);
dataPoints2.add(dataPoint23);
series2.setDataPoints(dataPoints2);
seriesList.add(series2);
dto.setSeries(seriesList);

Chart chart = (Chart)api.createShape("MyPresentation.pptx", 1, dto, null, null, null, null, null, null);
System.out.println(chart.getCategories().size());

PHP

use Aspose\Slides\Cloud\Sdk\Api\Configuration;
use Aspose\Slides\Cloud\Sdk\Api\SlidesApi;
use Aspose\Slides\Cloud\Sdk\Model\Chart;
use Aspose\Slides\Cloud\Sdk\Model\ChartTitle;
use Aspose\Slides\Cloud\Sdk\Model\ChartCategory;
use Aspose\Slides\Cloud\Sdk\Model\OneValueSeries;
use Aspose\Slides\Cloud\Sdk\Model\OneValueChartDataPoint;

$config = new Configuration();
$config->setAppSid("MyClientId");
$config->setAppKey("MyClientSecret");
$api = new SlidesApi(null, $config);

$dto = new Chart();
$dto->setChartType("ClusteredColumn");
$dto->setX(100);
$dto->setY(100);
$dto->setWidth(400);
$dto->setHeight(400);

$title = new ChartTitle();
$title->setText("Column Chart");
$dto->setTitle($title);

$category1 = new ChartCategory();
$category1->setValue("Category1");
$category2 = new ChartCategory();
$category2->setValue("Category2");
$category3 = new ChartCategory();
$category3->setValue("Category3");
$dto->setCategories([ $category1, $category2, $category3 ]);

$series1 = new OneValueSeries();
$dataPoint11 = new OneValueChartDataPoint();
$dataPoint11->setValue(20);
$dataPoint12 = new OneValueChartDataPoint();
$dataPoint12->setValue(50);
$dataPoint13 = new OneValueChartDataPoint();
$dataPoint13->setValue(30);
$series1->setDataPoints([$dataPoint11, $dataPoint12, $dataPoint13]);

$series2 = new OneValueSeries();
$dataPoint21 = new OneValueChartDataPoint();
$dataPoint21->setValue(30);
$dataPoint22 = new OneValueChartDataPoint();
$dataPoint22->setValue(10);
$dataPoint23 = new OneValueChartDataPoint();
$dataPoint23->setValue(60);
$series1->setDataPoints([$dataPoint21, $dataPoint22, $dataPoint23]);
$dto->setSeries([ $series1, $series2 ]);

$result = $api->CreateShape("MyPresentation.pptx", 1, $dto);
print(count($result->getCategories()));

Ruby

Python

import asposeslidescloud

from asposeslidescloud.configuration import Configuration
from asposeslidescloud.apis.slides_api import SlidesApi
from asposeslidescloud.models.chart import Chart
from asposeslidescloud.models.chart_title import ChartTitle
from asposeslidescloud.models.chart_category import ChartCategory
from asposeslidescloud.models.one_value_series import OneValueSeries
from asposeslidescloud.models.one_value_chart_data_point import OneValueChartDataPoint

configuration = Configuration()
configuration.app_sid = 'MyClientId'
configuration.app_key = 'MyClientSecret'
api = SlidesApi(configuration)

dto = Chart()
dto.chart_type = 'ClusteredColumn'
dto.x = 100
dto.y = 100
dto.width = 400
dto.height = 400

title = ChartTitle()
title.hasTitle = True
title.text = 'Column Chart'
dto.title = title

category1 = ChartCategory()
category1.value = 'Category1'
category2 = ChartCategory()
category2.value = 'Category2'
category3 = ChartCategory()
category3.value = 'Category3'
dto.categories = [ category1, category2, category3 ]

series1 = OneValueSeries()
data_point11 = OneValueChartDataPoint()
data_point11.value = 20
data_point12 = OneValueChartDataPoint()
data_point12.value = 50
data_point13 = OneValueChartDataPoint()
data_point13.value = 30
series1.data_points = [ data_point11, data_point12, data_point13 ]

series2 = OneValueSeries()
data_point21 = OneValueChartDataPoint()
data_point21.value = 30
data_point22 = OneValueChartDataPoint()
data_point22.value = 10
data_point23 = OneValueChartDataPoint()
data_point23.value = 60
series2.data_points = [ data_point21, data_point22, data_point23 ]
dto.series = [ series1, series2 ]

result = api.create_shape("MyPresentation.pptx", 1, dto)
print(len(result.categories))

Node.js

const CloudSdk = require("asposeslidescloud");
const api = new CloudSdk.SlidesApi("MyClientId", "MyClientSecret");

const chart = new CloudSdk.Chart();
chart.chartType = CloudSdk.Chart.ChartTypeEnum.ClusteredColumn;
chart.x = 100;
chart.y = 100;
chart.width = 400;
chart.height = 400;

title = new CloudSdk.ChartTitle();
title.text = 'Column Chart';
chart.title = title;

chart.categories = [{ value: "Category1" }, { value: "Category2" }, { value: "Category3" }];

const series1 = new CloudSdk.OneValueSeries();
series1.dataPoints = [{ value: 20 }, { value: 50 }, { value: 30 }];
const series2 = new CloudSdk.OneValueSeries();
series2.dataPoints = [{ value: 30 }, { value: 10 }, { value: 60 }];
chart.series = [ series1, series2 ];
api.createShape("MyPresentation.pptx", 1, chart).then((result) => {
    console.log(result.body.categories.length);
});

cfg := asposeslidescloud.NewConfiguration()
cfg.AppSid = "MyClientId"
cfg.AppKey = "MyClientSecret"
api := asposeslidescloud.NewAPIClient(cfg)

dto := asposeslidescloud.NewChart()
dto.ChartType = "ClusteredColumn"
dto.X = 100
dto.Y = 100
dto.Width = 400
dto.Height = 400

title := asposeslidescloud.NewChartTitle()
title.Text = "Column Chart"
dto.Title = title

category1 := asposeslidescloud.NewChartCategory()
category1.Value = "Category1"
category2 := asposeslidescloud.NewChartCategory()
category2.Value = "Category2"
category3 := asposeslidescloud.NewChartCategory()
category3.Value = "Category3"
dto.Categories = []asposeslidescloud.IChartCategory { category1, category2, category3 }

series1 := asposeslidescloud.NewOneValueSeries()
dataPoint11 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint11.Value = 20

dataPoint12 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint12.Value = 50

dataPoint13 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint13.Value = 30
series1.DataPoints = []asposeslidescloud.IOneValueChartDataPoint { dataPoint11, dataPoint12, dataPoint13 }

series2 := asposeslidescloud.NewOneValueSeries()
dataPoint21 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint21.Value = 30

dataPoint22 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint22.Value = 10

dataPoint23 := asposeslidescloud.NewOneValueChartDataPoint()
dataPoint23.Value = 60
series2.DataPoints = []asposeslidescloud.IOneValueChartDataPoint { dataPoint21, dataPoint22, dataPoint23 }
dto.Series = []asposeslidescloud.ISeries { series1, series2 }

result, _, e := api.SlidesApi.CreateShape("MyPresentation.pptx", 1, dto, nil, nil, "", "", "", "")
if e != nil {
    fmt.Printf("Error: %v.", e)
} else {
    fmt.Printf("%v categories.", len(result.(asposeslidescloud.IChart).GetCategories())) //3
}

C++

Perl

Swift

Create a Pie Chart