adding a threashold line in a chart

[alvarito]

How can I add a threashold line on a chart. For example, I have a bar chart which has all different kinds of values but none of the values go above 100. Yet I want to add a line that shows that the threashold is, say 500. What's the best way to do this on the run. What do I have to do in the spreadsheet, or where should I put this threashold value in the spreadsheet so I can use it on graph when I graph the other values? If this is not clear, let me know. I'll expand on this. thanks.

Alvarito

 

[Andrew Poulsom]

I think you just need to plot (as a line) another range in which all the values are 500.

 

[IML]

the following was helpful for me, perhaps you can use a secondary axis as outlined here:

http://216.92.17.166/board/viewtopic.php?topic=24773&forum=2