How to fix pie charts size in SSRS

0
votes

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

2
reporting-servicespropertiessizepie-chart
Unfortunately, while you can set the size of the chart element, the size of the pie will change due to the changing Legend that you have. The other option would be to make your own legend but then you'd need to assign the colors to the data rather than use the color scheme. Maybe try duplicating each chart and hide the Pie in one and the remove the legend from the other? Since they're in the same order, the colors should match. – Hannover Fist
Thank you, @Hannover Fist..., - I tried coping charts, but since I have multiple datasets for each of the pie chart - it only showed the dataset assigned to my 1st pie. And if I create a new chart - it shows all datasets (which what I needed) Is there any way to show all datasets to a copied chart? – Hell-1931

2 Answers

2
votes

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.

0
votes

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.