+ Reply to Thread
Results 1 to 1 of 1

VBA chart limits

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    62

    VBA chart limits

    Hi,
    Hope someone can help me.
    I have upper and lower limits on a scatter chart. and VBA code that determines if the chart is a pass or a fail. VBA code is referencing the limits at 5 different points on the chart. for the chart to pass all points must be between the upper and lower limit. However it only seems to be reading the first point and determining if that is a pass or fail for the whole chart.

    Sorry I couldn't attach the sheet as the file size was too big but here is a jpeg of the chart and the code that relates to it. also attached is the reference sheet for the x and y plot for the graph.
    red graph.png

    Please Login or Register  to view this content.
    Any help would be much appreciated. Thanks in Advance

    Steve
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating Pivot chart threshold limits
    By MasterElaichi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2014, 09:26 PM
  2. Line Chart data point limits
    By randinator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2014, 11:17 AM
  3. Stacked Column Chart showing the Limits
    By rose4emi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 04:15 AM
  4. Many specification limits in one control chart (?)
    By atabac in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-07-2010, 05:26 PM
  5. [SOLVED] Help setting scale limits on chart
    By Jerome Ranch in forum Excel General
    Replies: 2
    Last Post: 07-01-2006, 06:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1