CODEWITHSUNDEEP
reporting-servicespropertiessizepie-chart
Hell-1931
Hell-1931

Reputation: 509

How to fix pie charts size in SSRS

I have 4 charts created in SSRS 2017 and I need them to be the same size. Are there any settings (and where? in SSRS) to make size all the same for all of my 4 charts?

When I go into Chart Area properties, there is nothing about the chart size...

Please help!

enter image description here

Update: When I clicking on the Chart Area slightly outside the actual chart I see the following Chart Properties: enter image description here

Upvotes: 0

Views: 3321

Answers (3)

Jeff
Jeff

Reputation: 352

For me the above didn't help. The varying sizes of pie charts related to the fact that some had been set to have their series value > label > position = outside and others were position = auto. All pie charts had their labels hidden so you coudln't see them at all but SSRS was allowing space for them when set to position = outside. This made it extremely frustrating to chase down where the difference in size was coming from. Hope this may help someone who comes across a similar issue.

Upvotes: 0

Alan Schofield
Alan Schofield

Reputation: 21703

You can control the position of the chart area and the plot position of the pie within the area by setting the CustomPosition and CustomInnerPlotPosition properties. Select the chart area first to see these properties.

Please note: You must select the CHART AREA object in the designer not the chart Just click slightly outside the pie to select the correct area then you will see these properties.

enter image description here

You can do the same for the legend too if required so you can get full control over the final rendered size.

It does take a bit of trial and error to get a layout that suits all your needs but it can be done.

Upvotes: 2

Strawberryshrub
Strawberryshrub

Reputation: 3399

You cant directly influence the size of the chart, like Hannover Fist said it depends on multiple conditions (for example the legend). What you can do is to put the legend on top or on bottom of the chart (the reason for the different sizes of your charts it that the legend text from right to left is different, thus it uses the space from the visual). This way the size of the chart should be more or less the same size. Right click on your legend Legend properties > General > Legend position. With the MaxAutoSize property from the legend you can a little bit control the size of your legend.

To your second question. No, a chart (also tablix and matrix) can only have one Dataset as source. You can see this in the chart properties at the drop down list. You just can chose one element. But you can create one big dataset with all the data for the different charts. Then assign this dataset to one chart and copy it. And then you set different filters to the charts.

Upvotes: 0

Related Questions