Drawing a 'target' line in a line chart for comparison purposes

[Sinead]

Hiya,

I want to draw a line across the top of a line chart so that actual values can be compared with the targeted value (inputted by user). Can anybody tell me how to do this?

 

[jbearcat]

I don't have the answer. In fact I was searching for an answer to the same question. The problem I am having is that I can draw the line, but it is immediately pushed behind the graph. Even if I format the graph background as transparent, the lines still do not appear. However, if I move the chart, the lines I have tried to draw are there behind the chart. How do you draw on the chart itself?

 

[mbarron]

Create a formula to display the value (parameter field) that was entered by the user. The formulafield doesn't need to be added to the report. You can then add this formula field to your chart data.


whileprintingrecords;
{?control line} Mike
If you're not part of the solution, you're part of the precipitate.

 

[chelseatech]

Mike is correct, except that the formula needs to be:
WhileReadingrecords;

You can also use this with a hard coded contstant value as in:
WhileReadingrecords; 65

If you dont put the evalaution time in, the formula is calculated "BeforeReadingRecords" and isn't available for charts. And WhilePrintingRecords is too late for charts in some versions of CR. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm