split Report Builder chart into two chart areas to spread out data

I have a bar chart in Report Builder 2.0 that has a lot of values along the y-axis. I would like to split the chart to show two chart areas, or even have two separate charts, 开发者_StackOverfloweach with only half of the values on the y-axis. So chart 1 would have y-axis values A, B, C, and D, while chart 2 would have E, F, G, and H. I was thinking I could have a filter on the chart so that it only showed rows where ColumnValue < E (for chart 1) and ColumnValue >= E (for chart 2). How can I write such a filter, though? It'll probably need to do Round(Count(ColumnValue) / 2) to get the index of the middle value, but then how do I actually get what that value is (e.g., E) for comparison?

Or maybe there's some built-in way of prettifying a chart by splitting it into two separate charts to break up a long axis. I don't know. Suggestions?

Try using two graphs from the same source dataset, with a filter on on the first graph like the following:

RunningValue(Fields!GroupFieldName.Value,CountDistinct) <= CountDistinct(Fields!GroupFieldName.Value) / 2

- and a similar formula on the second, with <= replaced by > .