+ Reply to Thread
Results 1 to 3 of 3

Color scale conditional formatting in a bubble graph

Hybrid View

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    76

    Color scale conditional formatting in a bubble graph

    Hello all,

    I've got a bubble graph going where the difference in size between bubbles is somewhat difficult to detect. Was wondering if it was possible to have color scale conditional formatting within a bubble graph. I'd like to make the difference in size of each bubble more obvious by applying a color scale relative to each point's value.

    I've attached an example. The values that determine the sizes of the bubbles are in the column labeled PCT 3.

    Any help would be appreciated!

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Color scale conditional formatting in a bubble graph

    Maybe this might help

    http://www.excelforum.com/excel-char...ble-chart.html

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Color scale conditional formatting in a bubble graph

    That was helpful, JieJenn, thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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