Progress® Telerik® Reporting R3 2017

How to: Create Polar Chart

In this article we will show you how to create a Polar chart using the Graph item.

Polar Chart
  1. Add a new graph item to the report.

    1. Set the DataSource property to a new SqlDataSource.

    2. Set the connection string to the demo AdventureWorks database.

    3. Set the query to the following one:

      SELECT SOD.LineTotal, SOH.OrderDate, PC.Name AS Category
      FROM Sales.SalesOrderHeader AS SOH
      INNER JOIN Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID
      INNER JOIN Production.Product AS P ON SOD.ProductID = P.ProductID
      INNER JOIN Production.ProductSubcategory AS PS ON P.ProductSubcategoryID = PS.ProductSubcategoryID
      INNER JOIN Production.ProductCategory AS PC ON PS.ProductCategoryID = PC.ProductCategoryID
    4. You can click on Execute Query... just to check if everything is OK with the database connection. Click Finish when you are ready.

  2. Open SeriesGroups collection editor and click Add:

    1. Set the new group Groupings to: =Fields.OrderDate.Year

    2. Set the Sortings to: =Fields.OrderDate.Year

    3. Set the Name to seriesGroup1

  3. Open CategoryGroups collection editor and click Add.

    1. Set the new group Groupings to: =Fields.Category

    2. Set the Sortings to: =Fields.Category

    3. Set the Name to categoryGroup1

  4. Open CoordinateSystems collection editor and Add a new PolarCoordinateSystem.

    1. Leave the Name to polarCoordinateSystem1.

    2. Set the RadialAxis to New Axis Logarithmic Scale.

    3. Set the AngularAxis to New Axis with Category Scale.

  5. Open Series collection editor and Add new BarSeries.

    1. Set the CategoryGroup to categoryGroup1.

    2. Set the SeriesGroup to seriesGroup1.

    3. Set the CoordinateSystem to polarCoordinateSystem1.

    4. Set the ArrangeMode to Clustered.

    5. Set the Y value to =IsNull(Sum(Fields.LineTotal), 0) / 1000.0

  6. Set the color palette, the formatting of the labels, the values of the legend and any other improvements as needed.

    For more information, see Formatting a Graph.