Results 1 to 7 of 7

Thread: Ploting XY co-ordinates

  1. #1

    Ploting XY co-ordinates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    I need to plot the XY co-ordinates using data in sheet1 and plot them in sheet2 using macros.
    Code:
    X     Y
    5     5 
    6     4
    7     3
    8     7
    3     1
    5     3
    9     6
    7     12
    want to mark the X and Y axis according to the MAX value in each axis starting from ZERO and then plot the corresponding value...

    So in this case the X-AXIS start from 0-9 and Y-AXIS from 0-12.

    Any idea how to achieve this using macro.The chart can be of any type.Later i need to draw wafermap using this.

    Thanx

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Hi there, and welcome to the forum!

    Here's what I would do... build your chart manually. Once you're comfortable with the steps to get what you want, then turn on the macro recorder and do it again. Once you have, then post the code here and we'll help you make it dynamic and more efficient.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3

    Plotting XY co-ordinates

    Hi Ken,

    Here is what i am looking.

    I have a excel sheet with three Columns.X value,Y value and third columns called BIN.
    I shall show u a sample values as below.
    Code:
    X     Y    BIN
    4     3      1
    7     5      4
    8     2      3
    7     1      1
    3     5      6
    2     6      4
    1     3      9
    When i tried to plot graph manually by recording Macro here is what i get.
    Code:
    Sub Plot()
        Range("B3:C10").Select
        ActiveSheet.Shapes.AddChart.Select
        ActiveChart.SetSourceData Source:=Range("'Sheet1'!$B$3:$C$10")
        ActiveChart.ChartType = xlXYScatter
    End Sub
    But actually is it possible to plot the points in a EXCEL sheet rather than on a chart.
    I have attached a .xls file.That looks similar to what i want to achieve.Its called the wafer Map.

    Its just plotting the X and Y points with corresponding BIN number recorded in that point.And as the Range of X and Y axis varies each file its better to have it dynamic as per MAX value of X and Y axis.

    I hope u can understand once u have a look into this Excel file.

    Thanx

    sample_wafer.xls

  4. #4
    Hi Ken,

    I expect the rules are same accros all Excel forums.I have provided the link of the pages where i have cross posted the question.
    But i am still haven't got a reply i am expecting.

    http://www.excelforum.com/excel-char...-wafermap.html

    Thanx

  5. #5
    I request the moderators to delete this thread.

    Thanx

  6. #6
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Quote Originally Posted by asheshrocky View Post
    I expect the rules are same accros all Excel forums.I have provided the link of the pages where i have cross posted the question.
    But i am still haven't got a reply i am expecting.
    Hi aseshrocky,

    I apoligize for not getting back to you. To be fair though, it took you two days to reply to my request for more info, which you gave on a Sunday. This is a volunteer forum, and I wasn't on as it was a long weekend in my home town.

    I'm glad you got your answer at Ozgrid, and thank you for posting the link to excelforum. You're welcome to come back again, and hopefully we can do better with timing.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  7. #7
    Hi Ken,

    I will be back soon with more questions....am sorry for the time schedule.
    I know u guys are doing a great work by helping freshers like us.....keep the work going.

    Thanx

Posting Permissions

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