[Removed urgent from subject line - you’ll get a better response without it - Nick]
Listers
I need to set up a threshold line in a graph.
It should be say at -10 and +10.
A line all the way along the length of a chart.
10 -----------------------------------------------------------------------
5
0
5
10 ----------------------------------------------------------------
How do we do this?
I assume we cant use the alerters in the charts .
r_kishore (BOB member since 2002-08-20)
Create a variable called: Threshold and hard-code it’s value to 10.
Then add this variable to your chart as a secondary Field (and turn it into a line chart).
That should give you what you want.
digpen 
(BOB member since 2002-08-15)
But…
It puts that variable in the legend . Can we remove it from the legend alone
r_kishore (BOB member since 2002-08-20)
I don’t think so… You’d have to cover it with a solid white cell, or somesuch to hide it. You can’t have it filtered (for the legend), but displayed in the table, since they have to sync.
digpen (BOB member since 2002-08-15)
Although not exactly what you are looking to do, there is a tip on the BO tech support site (tip 'n tricks) that shows how to do alerts on a chart.
Steve Krandel 
(BOB member since 2002-06-25)
I think you can cheat by resizing the legend box to show just the variable(s) you want to see - assuming you have added them to the chart in order of the ones you want followed by the threshold lines…cunning eh? 
Nick Daniels 
(BOB member since 2002-08-15)
Let me ramble and think out loud.
The Legend is based on the displayed variables…
What if the threshold was on a separate axis… Would it still appear in the legend.
What if you used “=If then Else” type logic to blank out the name of Threshold for your titles… Would a “Blank” legend item bother you?
Thanks!
-RM
digpen (BOB member since 2002-08-15)
This is an old post so I hope you will still reply. The above references tip 'n tricks on BO tech support. Can you please provide an exact link? Is this the support web on businessobjects.com that requires a log in? The topic of needing an alert on a chart is exactly what I need.
Thanks
saspness (BOB member since 2005-03-21)
Thanks for the link. It doesn’t help with this issue, but I saw a couple of other interesting items. I guess there is not a way to set an alert on a bar graph that will make some of the bars red if a specific threshold is met. Maybe XI wil have that. 
saspness (BOB member since 2005-03-21)
Hi saspness
There is a way to add an alerter but it only works on bar charts so should work for you. This will change your columns to different colours.
Please see the post below
If you have any problems please post back or attach your report and let us know what the alerter you want to set and i will try and have a look for you
irish_stan 
(BOB member since 2003-05-13)
Perfect!! Awsome!! Thanks… 
saspness (BOB member since 2005-03-21)
(BOB member since 2002-06-20)