Insert a static line in charts

[leoraj]

Hi,

Can any one tell me how to insert a static line for Average in the charts. I have a measure(eg: sales) that is shown as bars for each product, how to insert a line that shows average/target sales on that chart, to compare how the current sales are doing, if they are above the line or below the line.

Thanks,
Raj

[rockytopmark]

That would be a second series.  There is also a Baseline attribute to charts, but it will generate a separate query.

[leoraj]

Thanks. The baseline attribute worked.