+ Reply to Thread
Results 1 to 2 of 2

Creating Bubble Chart

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    1

    Creating Bubble Chart

    Hello, I'd like to create a bubble chart with a set of non-numerical data, is this possible? The x and the y axis are both the names of media outlets (BBC, CNN, etc.). Any time they reference each other, I put a "1" at the intersection of the two outlets. For example, if a CNN article references a BBC article there is a 1 if 1 reference, two if two references, etc. I figured the bubble chart would be the best way to represent the strength of the connection between the two outlets. I've attached the doc. If anyone has any other possible suggestions for how to best visualize this data in chart form that would be great.
    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,482

    Re: Creating Bubble Chart

    How about using conditional formatting to produce a heat map.

    If you where to use a bubble chart you would need to assign each name a numeric value and build a set of x,y,size data.
    The scales would both be numeric so you would need to add dummy series and link data labels to cells in order to fake textual axes.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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: 0
    Last Post: 01-31-2012, 06:00 AM
  2. Replies: 1
    Last Post: 12-02-2011, 07:34 AM
  3. 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
  4. Creating X & Y Mean Lines on Bubble Chart
    By Chris Turnbull in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2006, 04:10 PM
  5. [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

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