I will need to create a barchart in SQL Reporting Services 2008. This chart will need more than 1 x-axis series. I want to be able to build this directly in SharePoint 2007 using SQL's Report Builder. How can this be done?

Hi Lmred, Actually, a chart has two axis types: primary and secondary. The secondary axis is useful when comparing two value sets with two distinct data ranges that share a common category, please follow below steps: To plot a series on the secondary axis 1. Right-click the series in the chart or right-click on a field in the Values area that you want to display on the secondary axis and click Series Properties. The Series Properties dialog box appears. 2. Click Axes and Chart Area, and select which of the secondary axes you want to enable, the value axis or the category axis. If you have any other question, please feel free to ask. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.