+ Reply to Thread
Results 1 to 4 of 4

Labels on a XY scatter plot are no longer correct when using filters

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Holland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Labels on a XY scatter plot are no longer correct when using filters

    Hi guys,

    I've got a problem that you can hopefully help me with. I've created a 2x2 matrix using a scatter plot and attached names as labels using the JWalk chart tools. However because of the size of the dataset filtering is absolutely necessary. Here is my problem, as soon as I use filters the data points in the matrix are still correct, the attached labels however make no sense anymore. Can you help me with this please? I've attached an example showing my problem.

    Thanks a lot!

    Rinze
    Attached Files Attached Files

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

    Re: Labels on a XY scatter plot are no longer correct when using filters

    See the work around and explanation of the problem here
    http://www.andypope.info/ngs/ng57.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    Holland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Labels on a XY scatter plot are no longer correct when using filters

    Hi Andy,

    Thanks for your reply! I've seen your work and tried to implement your solution, unsuccessfully unfortunately. Would it be helpful if I tried again and uploaded the sheet? I probably made some mistakes somewhere.

    Thanks

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

    Re: Labels on a XY scatter plot are no longer correct when using filters

    It would help to see your attempt if you have already tried that approach

+ 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