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. #13
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    In the attached chart with 2 plots. Row plotted is dependent on the value in V1 of Sheet5, which is dependent on the selection on that sheet.
    I suspect this data isn't very cose to real data! Both plots are always bang on top of each other.
    The chart has 2 sets of axes. Only one vertical one showing, since they're both always 0 to 80.

    This is intriguing; what are you looking to do, what are you looking for?
    Re:"will allow me to see any points of changes to the data if any occured", I strongly suspect you can find these changes with some relatively simple arithmetic.
    If you don't want to answer this in the publc domain you can always Private Message me at this site.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

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
  •