Dual y-axis chart combo chart

Can reporting service 2000 do combo chart (column and line) with two y-axis?Hi,
You can place two charts side by side.
Amarnath
"qye2020" wrote:
> Can reporting service 2000 do combo chart (column and line) with two y-axis?
>
>|||Use the "Plot data as line" option to mix lines with bars or with columns.
I was able to develop a way to simulate a second y axis. In my case the
data source was a cube. I had two types of series, one with large, whole
numbers, and one with percentages, which caused the percentages to be at the
zero point when displayed with the other type of series. My solution was to
write a calculated member that found the maximum value of the whole number
series for all rows, and to round that value up to the next highest number.
Therefore, if the series returned 8,235 as the maximum value in any row, the
result of my calculated member would be 9,000. The 9,000 value of the
calculated member was returned for every row. In the graph I used the value
property of the percentage series to multiply the actual value by my
calculated member value. I used the label property to obtain the actual
percentage value. Thus, 80% became .8 * 9000 for plotting purposes, but the
data point label said 80%. The result was a successful combination of the
two very different types of series. The only thing that I could not do
without a true second y axis was having the tick marks and labels of a second
axis along the right side of the graph.
--
Brian C. Berg
MCSE+I, MCDBA
Berg Information Technology, Inc.
This posting is provided "AS IS" with no warranties, and confers no rights.
"qye2020" wrote:
> Can reporting service 2000 do combo chart (column and line) with two y-axis?
>
>