SQL Server Reporting Services:将具有多个系列的图表的图例限制为一个系列
我有一个具有以下特征的图表:
图表类型是 XY(散点)
所有 XY 数据的 x 值都是整数; 它们被称为“更新周期”号码。 这表示来自给定程序的“分数”数据。
除了生成 XY 数据的值之外,我还在“值:”列表中添加了另外两个元素:一个是任何更新周期(x 轴)值的 XY 数据的平均值,以及另一个是任何更新周期的“类似程序”的平均值。 这些元素在图表上绘制为线条(“趋势线”)。
类别组是更新周期编号
系列组是 (1) PersonID 和 (2) ProgramID
这一切都很好,但这是我的问题:
如果我添加一个图例,它想要为每个人的每个点添加图例条目(因为 SeriesGroup1) - 我想它还会显示第二个系列的图例条目,但是第一个系列的内容太多了,我什么也看不懂。
问题:如何抑制第一个系列的图例条目并仅显示第二个系列的两个图例条目?
I have a chart with these characteristics:
chart type is XY (scatter )
all XY data have x-values that are integers; they are called "Update Cycle" numbers. This represents "score" data from a given program.
in addition to the values that produce the XY data, I've added two other elements to the "Values:" list: one that is the average of the XY data for any Update Cycle (x-axis) value, and another that is the average of "similar programs" for any Update Cycle. These elements are plotted as lines ("trend lines") on the chart.
Category Group is Update Cycle number
Series Group are (1) PersonID and (2) ProgramID
It all plots fine, but here's my problem:
If I add a Legend, it wants to add Legend entries for each and every point for each and every person (because of SeriesGroup1) - I imagine it's also showing legend entries for the second series, but there are so many for the first series, I can't read anything.
Question: How do I supress legend entries for the first series and only display the two legend entries for the 2nd series?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我有同样的问题,系列文本重叠有解决方案吗?,我找到了解决方案,但我无法使用,因为将图表划分为各种图表,顺便说一句,这是文章的链接:
http://social.msdn .microsoft.com/Forums/en-US/sqlreportingservices/thread/841e1515-3519-4c4f-a76f-f6fcebd25dfd/
如果有人有其他解决方案,请发布。
谢谢,抱歉,我的英语有点差。
I have the same problem, Is any solutions for the series text overlaping?, I found a solutions, but I cann't use, because divided the chart in various charts, by the way, heres is the link of the article:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/841e1515-3519-4c4f-a76f-f6fcebd25dfd/
If somebody have another solutions, pleace post it.
Thanks and sorry, my English is a little poor.