+ Reply to Thread
Results 1 to 5 of 5

Adding Special Chart Data Labels

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Lenexa, KS
    MS-Off Ver
    Excel 2010
    Posts
    13

    Adding Special Chart Data Labels

    I generate the data (Columns A,B & C) in the attachment weekly. Column D is a calculation based on data in columns A & B. The bubble chart is updated when the data is refreshed in columns A,B & C. I would like to add column D as data labels to the bubble chart. I realize that this poses a special problem since column D is not part of the data set for the bubble chart, but was hoping there is some way to add column D to the appropriate bubbles. It would make decision making based on the bubble chart much easier. If this requires some VBA code to be written to accomplish this, I would really appreciate it if you could supply the code, as I'm a novice at VBA code. Any help is much appreciated.
    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,419

    Re: Adding Special Chart Data Labels

    No need for vba if you can change your data layout.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Lenexa, KS
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Adding Special Chart Data Labels

    Okay, how would I rearrange it???

  4. #4
    Registered User
    Join Date
    08-21-2013
    Location
    Lenexa, KS
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Adding Special Chart Data Labels

    Oops! I just saw your attachment. I will look it over and see if I can modify it to fit your example.

  5. #5
    Registered User
    Join Date
    08-21-2013
    Location
    Lenexa, KS
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Adding Special Chart Data Labels

    I have looked it over and believe I can make it work that way. Thanks for the quick response and solution!!!

+ 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. [SOLVED] X-Axis labels disappear when adding data table to chart
    By phacexcel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-22-2012, 02:37 PM
  2. Adding extra labels to column chart
    By handerson0603 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-17-2012, 02:40 PM
  3. Adding custom labels to chart columns
    By ANP in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-07-2012, 07:30 AM
  4. Replies: 3
    Last Post: 12-19-2010, 11:04 AM
  5. Adding more data labels to pie chart
    By ctolson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-25-2010, 10:21 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