Excel 2010 Scatter graph - distinguishing multi same-value points

Posted on 2014-08-05
Last Modified: 2014-08-14
I'm wishing to create a scatter graph in Excel 2010 which has many points which have the same value.  Each point has significance and so I need to clearly distinguish and label them on the graph, so that when one looks at a point on the graph they can readily see which  points it relates to.
(I thought there used to be a setting for labels in which you could select option to not have labels overlap)

I have attached an attempt, poor and unsuccessful as it may be, to do this.
Question by:gh_user
    LVL 50

    Accepted Solution


    there is no easy, out-of-the-box tick box that you can select for this. In a previous question we had a lively discussion about the possibilities. See here.  

    cheers, teylyn

    Author Comment

    Hi Teylyn.
    Yes, I can see there is no easy solution from that discussion.
    I did a google search and came up with the following discussion (www
    in which add-ins such as chart labeller were suggested.
    Not sure if this would work, and how successful it would be if I need to share excel file with others (would they need to install addin)

    LVL 50

    Assisted Solution


    the chart labeller tool is very useful for sourcing label text from worksheet cells instead of the standard options (category, value), but it will not help in avoiding label overlap.

    This is a difficult challenge and there is no easy fix.

    cheers, teylyn

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now