Hi everyone! Is there any way in RDL/RDLC to connect a bar chart with a tablix., means a chart that contains bar chart with details connected below in a tablix respectively. pl. have a look at the below chart to understand my requirement. If we place them seperately, its not getting properly fixed as it is. Is there any way to interconnect the lower axis to the columns of the tablix. Pl. suggest me with a solution for this. Thanks in advance, kranthi kumar G.

Hi Kranthi, Based on you scenario, the closet approach I can think out is using Column Chart or Data Bar (avaiable in SSRS 2008 R2 or higher) in the matrix column group. The following steps are for your reference: 1. Right click the first row of the matrix, and insert a Inside Group - Above row. 2. Insert a 100% Stacked Column Chart or a 100% Stacked Column Data Bar into the second column of the first row. Drag the proper fields into the Values aread and Series Groups Area levaing the Category Groups area blank. If you use the 100% Stacked Column Chart, please make sure to remove the titles, Horizontal Axis, Vertical Axis Major Gridlines, and the legend. 3. Right click on the Series group of the chart, and open the Groups Properties dialog box. Click the Sorting tab, and set the sorting to be contrary to the sorting rule of the row group of the matrix. For example, change the "A to Z" to "Z to A" if you didn't modify the sorting option of the matrix row group. 4. To reset the width of the bars, please click the series bar, expand the "CustomAttributes" in the Properties pane, and set the "PixelPointWidth" to an interge value such as 20. 5. Design another column chart, adding a filter to the Category group to display only one value on the Horizontal Axis. Set the Fill color of the series to no color, and then remove all the items of the chart except for the Vertical Axis. 6. Drag the chart into the matrix corner. 7. For the legend, we can add another matrix on the right of the current matrix, set its textbox backgroud color to impersonate the chart legend. For more information, please se Setting custom colors on a column stacked bar chart. 8. Set the first row of the main matrix and the entire of the right matrix to "No Border". Note: The Vertical Axis length doesn't extactly match the bars in the matrix column group. I have not found an approach to avoid this. The screenshot below is for your reference: Hope this helps. Regards, Mike YinMike Yin TechNet Community Support

Hi Mike Yin, This is a great approach. You have mentioned one note there that says Note: The Vertical Axis length doesn't extactly match the bars in the matrix column group. I have not found an approach to avoid this. I am not sure but can we set max value for the vertical axis by putting the expression like =Max(Fields!SalesValue.Value, "DataSet1") that will resolve this limit?Aftab Ansari

Hi Aftab, Thanks for your posting. Based on the scenario, its a 100% Stacked Column Chart, so the data range of the Vertical Horizontal lable is 0~ 100%. So, we cannot set the label to use an expression as you suggested. For a column chart or a data bar, the height of the Vertial Axis will be changed automatically before or after we hide the Horizontal Axis. If we adjust the height of the chart in the martrix corner, the height of the first row will be increased at the same time. That way, the height of the bars in the column group will grow vertically as well. This is by design. Based on my test, we can avoid the issue by inserting rectangles into the matrix corner cell the column group cell. Before drag the charts into the rectangles, we can make the height of the chart that will placed in the matrix corner a little bigger than that of the chart placed in the column group cell. Please see the screenshot below: If you have any better suggestions, please let us know. Thanks, Mike Mike Yin TechNet Community Support