+ Reply to Thread
Results 1 to 3 of 3

Adding data labels to multiple series in a bubble chart

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Adding data labels to multiple series in a bubble chart

    Hi,

    I would like to add data labels to a bubble chart in version 2010 of excel without doing this manually. I am aware of the x y chart labeller, but my organisation have restricted access to downloading external programs.

    I have attached a copy of my workbook. I would like the bubbles to be titled with the project name (in cell E75 onwards). I have also created a "project name" range in the calculations tab in case it is possible to incorporate this into a macro.

    Any advice would be much appreciated.

    Many thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Adding data labels to multiple series in a bubble chart

    The heart of the procedure will be the DataLabel.Text property (help file for the DataLabel object https://msdn.microsoft.com/en-us/lib.../ff838393.aspx ) The second example in the help file shows how to add a datalabel to a single point and set the text property of that data label. You can link a data label text to a spreadsheet cell by using a "formula". Something like DataLabel.Text="=Chart!E75". This is basically what Rob Bovey's XY chart labeler add-in does, after it does all of the user interface stuff to know what series to label and what to use for labels. Put that inside of a loop (For..Next or For Each...Next) that will loop through all series in the chart and all data points in each series. Can I assume you are already familiar with these loop structures?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Adding data labels to multiple series in a bubble chart

    Thanks very much. Unfortunately my VBA knowledge is fairly limited and I am not familiar with looping or coding from scratch.

    I would also like the labelling to be more automatic and pick up on any additions to the raw data. If there was some way that it could look through the cells referenced by B7, C7 and D7 of the calculations tab, that would be great.

    Thanks in advance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  2. Bubble Chart Data Labels
    By 07cbennett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2014, 04:03 PM
  3. Bubble chart - help with macro set up for auto adding series
    By cjuba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2014, 07:31 AM
  4. VBA for adding text labels to a bubble chart
    By mljs54 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 11:41 AM
  5. Add labels to a bubble chart with multiple series
    By wahlberg in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-19-2013, 10:19 PM
  6. Bubble Chart - Multiple Series
    By David Brown in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-19-2011, 12:33 PM
  7. Replies: 3
    Last Post: 12-19-2010, 11:04 AM

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