Skip to content

Latest commit

 

History

History
92 lines (77 loc) · 5.64 KB

formatting-a-chart-report-builder-and-ssrs.md

File metadata and controls

92 lines (77 loc) · 5.64 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom f1_keywords
Formatting a chart in a paginated report
Improve the appearance of your paginated report chart and highlight data points using the formatting options found in the properties of each chart element in Report Builder.
maggiesMSFT
maggies
03/03/2017
reporting-services
report-design
conceptual
updatefrequency5
10214
sql13.rtp.rptdesigner.charttitleproperties.shadow.f1
sql13.rtp.rptdesigner.serieslabelproperties.font.f1
10149
sql13.rtp.rptdesigner.legendproperties.fill.f1
sql13.rtp.rptdesigner.seriesproperties.shadow.f1
10255
sql13.rtp.rptdesigner.seriesproperties.fill.f1
10154
10170
10173
10169
10158
sql13.rtp.rptdesigner.minorgridlineproperties.gridlineoptions.f1
sql13.rtp.rptdesigner.calculatedseriesproperties.borders.f1
10246
sql13.rtp.rptdesigner.serieslabelproperties.fill.f1
10150
sql13.rtp.rptdesigner.majorgridlineproperties.gridlineoptions.f1
10159
sql13.rtp.rptdesigner.chartproperties.fill.f1
10160
10182
10163
sql13.rtp.rptdesigner.charttitleproperties.fill.f1
10164
10253
10216
10171
10257
sql13.rtp.rptdesigner.chartareaproperties.shadow.f1
sql13.rtp.rptdesigner.chartareaproperties.fill.f1
sql13.rtp.rptdesigner.calculatedseriesproperties.fill.f1
sql13.rtp.rptdesigner.charttitleproperties.font.f1
sql13.rtp.rptdesigner.seriesproperties.markers.f1
sql13.rtp.rptdesigner.calculatedseriesproperties.shadow.f1
sql13.rtp.rptdesigner.charttitleproperties.borders.f1
sql13.rtp.rptdesigner.chartareaproperties.border.f1
sql13.rtp.rptdesigner.chartproperties.border.f1
10247

Formatting a chart in a paginated report (Report Builder)

[!INCLUDEssrs-appliesto] [!INCLUDE ssrs-appliesto-ssrs-rb] [!INCLUDE ssrs-appliesto-pbi-rb] [!INCLUDE ssrb-applies-to-ssdt-yes]

After you have defined the data for your paginated report chart and it is appearing the way you want, you can add formatting to improve the overall appearance and highlight key data points. The most common formatting options can be modified from the Properties dialog box that are found when you right-click a chart element to display its shortcut menu. Each chart element has its own dialog box. For more information about chart elements, see Charts (Report Builder and SSRS).

All properties that relate to the chart are located in the Properties pane, but many of these properties can also be set from a dialog box. If you are formatting the series, you can specify series-specific properties using custom attributes, which can only be found in the CustomAttributes category of properties, located in the Properties pane.

To effectively format the chart using a minimal number of steps, change the default border style, palette and drawing style. These three features produce the largest visible change on the chart. Drawing styles are only applicable to pie, doughnut, bar and column charts.

Note

[!INCLUDEssRBRDDup]

In This Section

Formatting Series Colors on a Chart (Report Builder and SSRS)
Discusses how colors are defined using a palette, how you can define your own color palette, and how to define colors based on an expression.

Formatting Axis Labels on a Chart (Report Builder and SSRS)
Discusses how to display gridlines, tick marks, and titles, and how to format numbers and dates on the axis scale.

Formatting the Legend on a Chart (Report Builder and SSRS)
Discusses how to re-order and format items in the chart legend.

Formatting Data Points on a Chart (Report Builder and SSRS)
Discusses how to position data point labels and format data point markers for every series on the chart.

3D, Bevel, and Other Effects in a Chart (Report Builder and SSRS)
Discusses various 3D effects that you can apply to a chart.

Add a Border Frame to a Chart (Report Builder and SSRS)
Explains how to add a border frame to a chart.

See Also

Charts (Report Builder and SSRS)
Add a Border Frame to a Chart (Report Builder and SSRS)
Define Colors on a Chart Using a Palette (Report Builder and SSRS)
Add Bevel, Emboss, and Texture Styles to a Chart (Report Builder and SSRS)