+ Reply to Thread
Results 1 to 2 of 2

Create a bubble chart with text on both axis

  1. #1
    Registered User
    Join Date
    03-15-2016
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2016
    Posts
    23

    Create a bubble chart with text on both axis

    Hi there,

    I am trying to make the following bubble chart with excel:

    electrical electronics persistent.png

    I want 'job positions' on the Y axis (Entry level, Junior executive, Senior executive, Manager, Senior manager) and the different 'job titles' on the X axis. The size of the bubbles are according to the 'size' of the numbers. So, if you have an Engineer (job title) in Senior Executive position occurs 7 times the bubble will be bigger than an Engineer on entry level which occurs 2 times. I attached a file with example data.

    Does anybody know if this is possible with excel? Or do I need to do it with some online program like done in the image?
    Attached Files Attached Files

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

    Re: Create a bubble chart with text on both axis

    My first thought is to adapt and expand a technique like this one: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Bubble chart x axis not using values
    By dkoli in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-10-2014, 10:20 AM
  2. Bubble Chart-Issue with Y Axis
    By Eric S in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2013, 07:37 AM
  3. Problem with axis for bubble chart
    By rebeccagrace in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-01-2012, 12:18 AM
  4. Bubble chart with additional Y axis values
    By Neffy812 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2011, 07:24 AM
  5. 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
  6. Category axis in bubble chart
    By Eric27 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2005, 06:00 PM
  7. [SOLVED] Bubble chart with names in X and Y axis instead of numbers
    By Federico in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-09-2005, 08:06 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