+ Reply to Thread
Results 1 to 2 of 2

Scatter Bubble Chart with text categories for vertical and horizontal axes

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Asheville, NC
    MS-Off Ver
    Office 2013
    Posts
    1

    Question Scatter Bubble Chart with text categories for vertical and horizontal axes

    I want to make a scatter bubble chart with vertical axis labels that display ranked levels and a horizontal axis that displays the category to be ranked. The size of the bubbles in the chart should correspond to the numbers in the dataset, and there would be multiple bubbles above each category on the horizontal axis. (See attached spreadsheet)Skill Ranking Data.xlsx

    How do I tell excel to use text categories for both the vertical and horizontal axes? And how do I get the bubbles in the scatter plot to correspond in size to the numbers within the dataset?

    (Please note: I don't have Power View)

    Thanks for any help!

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

    Re: Scatter Bubble Chart with text categories for vertical and horizontal axes

    Jon Peltier's "arbitrary axis" technique is quite useful for this sort of thing. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html He works through one example on this page, then links to other examples for different needs. I expect you should be able to adapt the method to your needs.
    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. Ploting with words on the vertical and horizontal axes
    By Renildrah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-29-2014, 03:42 AM
  2. Two vertical axes in one chart
    By a.janmohammadi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-30-2013, 08:16 AM
  3. Formatting axes of bubble chart
    By turtletello in forum Excel General
    Replies: 4
    Last Post: 08-03-2013, 06:20 AM
  4. Straight Vertical and Horizontal line through a single scatter point.
    By jhall488 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-10-2012, 10:06 AM
  5. mixed plot: scatter, vertical, and horizontal lines
    By confused_newbie in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-20-2005, 02:05 PM

Tags for this Thread

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