本文介绍了同一 SSRS 图表中的两种图表类型(条形图和折线图)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

SSRS 2005 如何在同一图表上表示两种图表类型(即条形图和折线图)?

我正在尝试创建一个看起来像下面专业制作的图像的图表:

I am trying to create a graph that looks like the professionally crafted image below:

该图表将有一个系列表示为条形图,然后另外两个系列表示为重叠的折线图.

The chart would have one series represented as bar graphs and then two other series represented as overlapping line graphs.

我有线图作为两个独立的系列工作,我可以编写我的 SQL 查询来返回条形图系列月份的空值和两个线系列上年份的空值以防止重叠,但我不看不到如何为每个系列指定图表类型.

I have the line graphs working as two independent series and I can write my SQL query to return empty values for the months of the bar graph series and empty values for the years on the two line series to prevent overlapping, but I don't see how to specify a chart type per series.

实际上,这可以使用 SSRS 来完成吗?还是视觉模拟?

Realistically, can this be done using SSRS? Or simulated visually?

推荐答案

选择图表,确保它突出显示并且图表数据框出现在图表右侧,您的两个系列都应列在值"中"部分.单击系列"值右侧的下拉箭头,使用此处的更改图表类型"选项(每个系列).这只会影响您单击下拉列表的系列:)

Select the Chart, make sure it is highlighted and the Chart Data box appears to the right of the graph, both of your series should be listed inside the "Values" section. Click the drop down arrow to the right of your Series' value, use the 'Change Chart type' option from here (per series). This will affect only the series you clicked the drop down for :)

这篇关于同一 SSRS 图表中的两种图表类型(条形图和折线图)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-29 15:18
查看更多