Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Location
    Fort Myers FL
    Posts
    7

    Add Text to chart when data = 0


    The chart generated from a query contains data for both temperature and flow over time. Occationally the data shows zero for n records. Time and zero data are still recorded.
    I need to place either a marker of some text over the zero data area on the chart stating "Communications Failure" as this is the reason for lost data.
    Any ideas to ackomplish this would be very much appreciated.

    Regards,

    Michael

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    I never use charts. So this is just a guess; in a report one would put a label with the text that you want - and have it be not visible; and then in the 'onformat' event you would use an if/then on that value to toggle it to visible or not.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  2. Design view not showing data (Pivot Chart)
    By thestappa in forum Reports
    Replies: 0
    Last Post: 06-24-2010, 09:59 AM
  3. Extracting text from XML data
    By rob4465 in forum Access
    Replies: 1
    Last Post: 03-18-2010, 06:41 PM
  4. How to add text data from records
    By er_manojbisht in forum Reports
    Replies: 3
    Last Post: 03-01-2010, 08:37 AM
  5. Chart doesn't show data
    By pbaxter in forum Forms
    Replies: 5
    Last Post: 01-20-2010, 11:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums