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

sean denney 1 Reputation point
2021-04-16T15:54:44.347+00:00

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,134 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points
    2021-04-19T07:33:21.487+00:00

    Hi @sean denney

    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

    No comments