Dual Y-Axes

Greetings,

I'm wondering if it is possible to have two independent y-axes on a single chart?

I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis.

I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way.

Thanks
--
AnthonyI think RS can't do it out of the box. Have a look at Dundas Charts.|||I was afraid you would say that. I will see if Dundas Charts has anything that will work, but I don't know that we are going to get that in our budget, so if anyone else knows of a way to rig RS to do it without Dundas, that would be great.

Also, from looking at the Dundas site, it appears they are only offering Dundas Charts for RS 2005 at this point. Whether it would still work with RS 2000, I don't know.
|||I know Dundas definately supports it, I use it quite regularly.|||

Keep in mind that the CustomReportItem-based extensibility (such as "Dundas Charts for Reporting Services" or similar offers from other third parties) are available for SSRS 2005 only in Standard, Enterprise, or Developer Editions.

It is not available for SSRS 2000.

-- Robert