SSRS Stacked Bar Chart with specific dataset

Marco Onnis 1 Reputation point
2022-09-01T08:24:31.057+00:00

Hello guys, noob here!

I need to create a simple column chart in SSRS and I have those data:

236789-image.png

Those values in cells are cluser of "production time" for two different phases of the process. the column "First+Second" adds them up.

basically i've already clustered and i wuold like to obtain a chart in which my x axes has the values [ < 0, 1, 2, 3, 4, 5, 6, 7, 8, >8] and the column shows the count of "FirstLimit" and, above, the "SecondLimit" ....

thanks a lot and I hope to have written something clear :D

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,799 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,316 Reputation points Microsoft Vendor
    2022-09-02T05:35:25.557+00:00

    Hi @Marco Onnis
    In a stacked bar chart, the x-axis is a value axis, displayed as the chart's numeric type values. On the value axis, the scale is always determined by the minimum and maximum numbers in the value field. For more details, you can refer to this link: formatting-axis-labels-on-a-chart-report-builder-and-ssrs.
    Best regards,
    Aniya

    0 comments No comments