+ Reply to Thread
Results 1 to 2 of 2

Plot is taking random data, when adding scatter to worksheet

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Latvia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Plot is taking random data, when adding scatter to worksheet

    Hi. This doesen't make any sence to me, but when I am using
    Please Login or Register  to view this content.
    this plot is taking random data.
    Please take a look at whole section, I marked in red row, where scatter is being made and select random data(at least it seemes random to me):
    Please Login or Register  to view this content.
    After end sub I have scatter with plots I need + several plots:untitled.jpg
    Please help with any ideas!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Plot is taking random data, when adding scatter to worksheet

    The data adjacent to the active cell will be used in the chart.

    Once the chart is created remove any data series
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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