Automatic custom labels on Excel scatter plot

October 17, 2007 Jesper Excel, Scripting Go to comment

Keywords: Excel, custom labels, XY plot chart, scatter plot, macro

Version: Tested on Excel 2003 and Excel 2007

Download:

Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function to insert custom labels; the only options available are Series names, x- and y-values which often are totally inappropriate. I created a workbook with a macro that allows the user to insert the X and Y data along with the desired lables and create a labled scatter plot with the click of a button. See image below.

Automatic custom labels on Excel scatter plot

All you have to do is to dowload the file, insert your labels and values and click the button! The chart may require some additional formatting to suit your needs. Enjoy!

Download: Click here

Popularity: 17% [?]


11 Responses to Automatic custom labels on Excel scatter plot

  1. Frank | #1
    On July 26, 2010 2:08 am

    Hi Jesper,
    Can’t seem to download your file. Any hints?
    Cheers,
    Frank.

  2. Jim / ShoenfeltConsulting.com | #2
    On October 13, 2009 11:22 pm

    Try this:
    http://support.microsoft.com/kb/213750

  3. Jai | #3
    On October 2, 2009 8:47 am

    When you publish the chart as a webpage with interactivity, i would like this to work. How do i make that possible.

  4. Jesper | #4
    On September 11, 2009 10:34 am

    This macro cannot be used for multiple series, a modification would be needed. Not sure I will have time to look at this now.

    Cheers

  5. Jocelyn | #5
    On September 10, 2009 10:09 pm

    Is there a way to plot multiple series (labeled) using this macro? This works great for single series, no matter how large, but does not allow me to plot multiple series with labels. Thanks!

  6. Jesper | #6
    On April 10, 2009 10:45 pm

    Mail sent, Bill :)

  7. Bill | #7
    On April 9, 2009 5:20 pm

    Can someone contact me to 1) learn how to transport this macro between spreadsheets and 2) tell me to how I can make a financial contribution? BTW, I tend to run into run-time errors fequently. Not sure why this happens.

    Thanks
    Bill

  8. Anil | #8
    On March 16, 2009 11:45 pm

    Great job, just a comment on label placement. If there is more than one data label with same x/y value then data labels overlaps – this reduces the readability of data labels. Thanks a lot, Anil

  9. Jesper | #9
    On March 12, 2009 9:01 am

    It works with my 2007. Try to enter new values in the Y category to make sure it’s not the formula messing things up.

  10. Steven Seagal | #10
    On March 12, 2009 8:00 am

    Just tried it in 2k7 and it doesn’t work.

  11. Avery | #11
    On March 11, 2009 11:48 am

    Whenever I try using the above script I keep running into an error. I am thinking that maybe I don’t have all of the correct references, but I was hoping someone coudl confrim.

    Thank you again!

    Avery