pivot chart help

[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!

 

[Lord Kelvan]

is this an excel question or an access question

 

[Irene]

dear Lord Kelvan,

this is access question. i'm using access to do the pivot chart.

 

[Lord Kelvan]

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