+ Reply to Thread
Results 1 to 7 of 7

Scattered Graph

  1. #1
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Scattered Graph

    Hi,

    I have three colums of data.
    First represet company , second colum represent data1 ( x- axis) and third represet data2 ( y-axis).

    I want to plot x-y graph with the company name

    Eg.
    McDon | 10 | 20

    In the above case i want to show a round circle or dot which will be 10 right on x axis and 20 up on y axis and near the dot i want to show McDon as company name.

    See that attachement... Graph is coming well.. but i am not able to add the company name to the dots.. or pot of x and y intersection
    Attached Files Attached Files
    Last edited by Shijesh Kumar; 02-17-2009 at 11:18 AM.

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Scattered Graph

    Solved myself...

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

    Re: Scattered Graph

    Care to share your solution?
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    02-17-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Scattered Graph

    Hi,
    This is onlinev from canada. I am a newbie of this site and in
    my opinion this is a good site to visit on for the visitors.
    It has a lot for the visitors.
    onlinev
    Finance Loans

  5. #5
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Scattered Graph

    Hi Andy,

    Here the vba which i tried to make.

    I'm not very good at chart .. so this is not a very good one to work with but it served my purpose

    Please Login or Register  to view this content.

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

    Re: Scattered Graph

    Thanks for posting that.

    You may find this free addin useful for linking data labels to cells.
    http://www.appspro.com/Utilities/ChartLabeler.htm

  7. #7
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Scattered Graph

    Thanks Andy,

    I have that link...
    But my office system does not allow us to download any exe or any executable files from internet...

    Thats why i have to create a inefficient macro to serve my need.

+ 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