Results 1 to 17 of 17

Thread: VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #14
    Thank you for the update, the data is actual and taken from the system, it's the processed road analysis data and is limited within the range of 0-80.
    They may appear to be currently overlapping however in perfect form the value is +1.75 and -1.75, occurrences of defects creates the variations.

    The current plot which you created works well, I've just changed the axis limits to my requirements as per photo, I do require the Start - Stop button to be enabled as well as the scroll (although it's limited to a maximum of 30k) which you added in the previous revision (which allowed to alter the value of Cell V1 quickly and allowed up and down arrow use to move sequentially).

    You're work is superb nonetheless!

    I would appreciate if I don't disclose specifics of the data itself, but the visualisation in the photo is exactly as wanted
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by aqibi2000; 10-26-2017 at 03:53 AM.

Tags for this Thread

Posting Permissions

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