placing norms on a bar chart

Maybe someone can help. I'd like to do one of two things, depending on which is actually possible:

Place one chart on top of another so that, in addition to having a simple bar chart, I can also have a way of tracking comparison data on the same chart. (My preference is a line chart with diamond markers on top of a bar chart.)Within one chart, have one of the series be a different chart type. Once series could be a bar and the next could be a line with diamond markers. The catch is the diamonds would have to be placed right on top of their corresponding bars.

These are both things that I've been able to do in Excel, but am finding out that I've taken for granted just how versatile Excel is.

Thanks in advance!

Krdjis

Did you look at the "plot data as line" option (in Report Designer, go to the Chart Properties dialog. Click on the Data tab, select the data point you want to make a line, click 'Edit..'. In the chart value dialog, click on the Appearance tab and select 'Plot Data as Line'.)?

You may also want to check out this MSDN article on RS charts: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/MoreSSRSCharts.asp

-- Robert