Benchmarking line in the chart

[Former Member]

Hi

I have created one VC model for comparitive analysis of feedack of the training program. Based on this i want some benchmark so that i can compare this with others. To do this i want to show some benchmarking line in my chart. How do i do this?

Thanks in advance

Deepdas

Edited by: Deepdas on Nov 6, 2009 4:16 PM

[Former Member · Accepted solution]

Hi

First you select chart type as 'Line or Combo'. Then in the data series drop down go to enter formula. then you give fixed number which is nothing but your benchmark. This will give you one complete line in the chart from which you can analyze what you want.

regards

sandeep

[Former Member · Accepted solution]

Hi

There is another way also of doing same thing -

1. First select 'Grid Lines' as Horizontal in the chart.

2. Then set value range manual & give min & max values.

3. Adjust interval size so as your 'Benchmark value' will come as one of the intervals.

Earlier what i explained is visible only if there are more than 1 values on category axis for a given field.

Regards

Sandeep