+ Reply to Thread
Results 1 to 5 of 5

For bubble chart missing data

  1. #1
    Registered User
    Join Date
    12-04-2017
    Location
    Auckland
    MS-Off Ver
    2011
    Posts
    9

    For bubble chart missing data

    Hello,
    I followed the setp to create a bubble chart, but the chart only showing part of the data, other data (China, India, Mexico) is missing, I wonder which step I did wrong, how can I solve this?
    Screen Shot 2017-12-05 at 10.01.05 PM.png
    Thanks

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: For bubble chart missing data

    I can see 5 of 6 sets plotted, while you claim 3 out of 6 are missing.

    To clarify, please attach a sample workbook. Make sure there is just enough data to demonstrate your need.
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    12-04-2017
    Location
    Auckland
    MS-Off Ver
    2011
    Posts
    9

    Re: For bubble chart missing data

    Hello Kaper
    Because base on the guidance, the data suppose to look like this, but in my file (see the attachment, only three color bubble labels are there
    Screen Shot 2017-12-05 at 10.22.22 PM.png
    Thanks
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: For bubble chart missing data

    Select only numbers range (B3:D8) and insert bubble chart. Then you can format it to your needs.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-04-2017
    Location
    Auckland
    MS-Off Ver
    2011
    Posts
    9

    Re: For bubble chart missing data

    Thank you so much, problem solved

+ 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. Plot data on Bubble Chart
    By maddoca in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-05-2012, 10:20 AM
  2. Edit bubble behind another bubble in bubble chart (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-14-2009, 03:10 PM
  3. Data labels on bubble chart
    By Whoflungdung in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-29-2008, 07:35 AM
  4. Bubble Chart is skipping data
    By Fabbe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-07-2007, 04:14 AM
  5. [SOLVED] How do I link a bubble in the bubble graph to another chart?
    By Pradnya Purandare in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2006, 12:25 AM
  6. How do i add text labels to each bubble on bubble chart?
    By bazza in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2005, 12:10 AM
  7. [SOLVED] ho to change in the bubble chart the bubble position and size
    By laszlo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2005, 01:06 PM
  8. Replies: 0
    Last Post: 02-20-2005, 04:06 PM

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