+ Reply to Thread
Results 1 to 3 of 3

How to automatically generate data series from table columns in bubble charts

  1. #1
    Registered User
    Join Date
    11-15-2003
    Posts
    3

    How to automatically generate data series from table columns in bubble charts

    Just consider the following problem. I have an Excel table with SIX columns: L, X, Y, S, A, B. I want to generate a SINGLE bubble chart with several data series.

    L column is used for LABELS
    X column is used for X-AXIS
    Y column is used for Y-AXIS
    S column is used for SIZE of bubbles

    So far, everything is ok. I know how to do it.

    No, I want to generate a data series for EACH combination of values of columns A and B. For example, if A is {F,G} and be is {1,2}, I want four series, F1, F2, G1, and G2, each one featuring a different bubble color.
    At the moment, the ONLY way I found to do that, is to sort the table by column A and B and manually set the data for each series. This is a very primitive approach, because if I delete or add records to table, I have to do it again. Furthermore, if I work on table by filtering or sorting records for other analysis, the chart is completely disrupted.

    Any idea how I can do that without using code?
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,120

    Re: How to automatically generate data series from table columns in bubble charts

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,890

    Re: How to automatically generate data series from table columns in bubble charts

    See extended table in attached. The additional columns use formula to output Y and Sizes if relevant
    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. Adding data labels to multiple series in a bubble chart
    By matrix_fan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2017, 11:29 AM
  2. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  3. Automatically Format Bubble Charts
    By ajm036 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-17-2015, 12:59 PM
  4. Trouble selecting correct data for bubble charts.
    By Mc837 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2014, 04:57 PM
  5. Making bubble charts with multiple series - BCG matrix
    By Pikka in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-31-2012, 10:21 AM
  6. [SOLVED] How do i move data series into other columns on column charts
    By JamesO in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-03-2006, 12:50 PM
  7. [SOLVED] Getting charts to automatically pick data from a series
    By Salmonh20 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2006, 02:45 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