Report spikes

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hi,

I have an access line graph report. Every now and then, there will be a
spike up or down for certain value. I want be able to put a note next to
the spike to explain the circumstances of what it happened.

As I run this report weekly, I don't want to have to add the note manually
everytime though - I want it to remember previous notes.

Any ideas to get me started?

Thanks,
Joel
 
Joel,
You could just place a Access normal label control on the graph (Brought to Front) with
a caption something like...
"This is an unusual event"
Since you never know where or if a spike will occur, you can just Hide the control,
until you need it. Then make it visible, and edit the caption for that circumstance.
There may also be a way to use Charting Labels to do this, but I think my suggestion
is a reasonable "work around" for an "Every now and then event."
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top