question

seandenney-7098 avatar image
0 Votes"
seandenney-7098 asked ZoeHui-MSFT answered

SSRS Column Chart - Make columns in same/standard width regardless of data

I have a Column chart with a simple count for values, A category grouping and a series group. The category group is a date on the horizontal axis.

My Question is Can the chart be configured in such a way that the bars will always be the same width ?(Assuming space is not an issue)

I have been playing with the custom properties
Ending up with this PointWidth=0.2, MaxPixelPointWidth=5, MinPixelPointWidth=5, PixelPointWidth=5 which looks close, but one thing I notice is
that the very last column ( on the last day of the horizontal axis is narrower than the rest. This may have a seperate setting to do with the border?

Just wondering how to best make the columns standard or expected width.

Thanks for any guidance

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @seandenney-7098

With CustomAttributes we may change the width of the columns and the columns in chart is always the same width.

It's by design so that the very last column's width issue will be more related with the chart size or just visual error.

To manually set the width of the columns in a chart, modify their width, in pixels, by modifying the PointWidth property.

By default, this property has a value of 0.8.

We could only set the value manually and test repeatedly to make the columns standard or expected width.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.