HI, i had a requirement where i need to show like price1 and price2 on that chart, the way i need to show it should be like this the Y-axis should be in the middle and for onside i need to plot price1 and other side i need to plot price2,can i achieve it in scattergram chart in BIDS 2008 , can some one help me out how to do that with some ref links thanks in advance

You could do a UNION ALL query for the chart's source, selecting Price1 and -Price2 (negative value) for the x-axis.-Tab Alleman