Online Documentation for Data Export for SQL Server

Charts


If you need to create a chart:

  • enter the chart title;
  • select the chart style (Column, Column 3D, Bar, Bar 3D, Line, Line Mark, Line 3D, etc.);
  • set the legend position: Bottom, Top, Left, Corner or Right;
  • specify if you want to show the legend;
  • specify if you want to set the chart color automatically;
  • define the chart position and category labels using the corresponding tabs.

 

Format-specific options - MS Excel - Extensions - Charts

 

Position

Position tab allows you to define chart placement and its size.

 

Format-specific options - MS Excel - Extensions - Charts - Position

 

Auto Position

RadioButton Bottom

The chart will be placed under the data.

 

RadioButton Right

The chart will be placed to the right from the data.

 

You also need to specify the distance between the chart and the data at the Left and the Top fields, and chart size at the Height and the Width.

 

Custom Position

Specify absolute position by setting chart coordinates: X1, Y1, X2, Y2.

 

Category labels

Use this tab to define Category labels.

 

Format-specific options - MS Excel - Extensions - Charts - Category Labels

 

RadioButton Column

Use column values as chart category labels.

 

RadioButton Custom

Define category label values range manually. Use Col 1 and Row 1 fields to specify upper left cell, and Col 2 and Row 2 fields to define the right bottom one. These cells form a square array of values that will be used as category labels.

 

If you need to add series for the chart:

  • add one or more series using the iconPlus button;
  • enter the titles;
  • set data ranges (select a column from the drop-down list or set the custom range);
  • define colors for all the graphs.

 

Format-specific options - MS Excel - Extensions - Series