pivot chart help

  • Thread starter Thread starter Irene
  • Start date Start date
I

Irene

i have a pivot chart and i would like to draw a line in the chart. that line
is my target. so how can i do it? can anybody help me? thanks!
 
well if it is based on a query add to the query

select *,ctin(targetvalue) as target
from thequery;

so you could place "60" as target value if that is your target value

that should then place the value 60 across all values in your piviot
chart as a straight horozontal line

alternativally you could open the query the chart is based on then
just add
target:cint("60")

as a expression and it should do the same thing.

as a note this isnt tested it is just simillar to something i did in
excel when using a line graph.

as a note you will have to set the target in the graph to max not sum.

hope this helps

Regards
Kelvan
 
Back
Top