问题描述
我正在使用SQL Server2012。SSRS
I am using SQL Server 2012. SSRS
我有一个堆积的条形图，其中包括利息和股息。我想将这些值的总和添加到堆积条形图上方的区域中。我曾尝试过调整标签的各种属性，但无法将标签位置放在堆叠条形图中间的任何位置。有什么想法如何使这些标签位于堆积的条形图的上方？
I have a stacked bar charts that includes interest and dividends. I would like to add the sum of these values to the area just above the stacked bar chart. I have tried adjusting various properties for the labels but I can't get the label position to be anywhere but the middle of the stacked bar chart. Any ideas how to get these labels to be just above the stacked bar charts?
推荐答案
无法通过设置来执行此操作。
There is not a way to do this with settings.
以下是一些链接，可为您提供逐步说明：
Here are a couple of links that give you step by step instructions:
- http://beyondrelational.com/modules/2/blogs/65/posts/11575/display-total-on-top-of-stacked-chart.aspx
- http://social.msdn.microsoft.com/Forums/sqlserver/en-US/654f30c2-ad3a-4b4e-a34f-adf4db6b78d2/stacked-column-chart-total?forum=sqlreportingservices
基本上，解决方法是在图表中创建总计的另一个系列或类别（这需要更新数据集以包括总计），透明，然后打开数据标签。 MSDN回答说要使其成为折线图，而《超越关系》一文则将其保留为堆积条形图的一部分。无论哪种方式都可以。
Basically, the workaround is to create another series or category in your chart that is the totals (which requires updating your dataset to include the totals), make it transparent, and turn data labels on. The MSDN answer says to make it a line chart while the Beyond Relational article leaves it as part of the stacked bar. Either way will work.
这篇关于SSRS堆叠条形图标签位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！