Results 1 to 5 of 5

Excel Bubble Chart with Upper & Lower bounds

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2013
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    33

    Question Excel Bubble Chart with Upper & Lower bounds

    Hi all,
    Here's my problem:
    - I'm making bubble chart to see the impact of forecast on TO performance:
    • X-Axis: TO Change
    • Y-Axis: Forecast bias (%)
    • Size: TO Value
    - I want to add in one more criteria, which is the upper & lower bound for forecast bias:
    • -2.5% to +2.5% is the bound where the forecast bias should be. Forecast bias higher or lower than this bound needs to investigate
    • Every categories with TO decrease while forecast bias is within range (-2.5+2.5%) is considered bad performance
    I want to highlight these upper & lower bound with area colored (like below pictures)
    bubble chart example.png
    Is there anyway to make this automatically in bubble chart?
    One of my thought is to make another chart behind this with the selected criteria. the problems is the axis is not matching with each other & it is troublesome to change when the data change

    Could you help me with any better solution?
    Thank you
    Attached Files Attached Files
    Last edited by tranhaithang; 12-10-2014 at 09:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Solver - Evoloutionary, how to apply upper and lower bounds
    By dpsersimon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 02:26 AM
  2. [SOLVED] Determine if a cell value is within upper and lower bounds?
    By Darksabre in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-03-2013, 01:30 PM
  3. [SOLVED] Multiple if statements with upper/lower bounds
    By crail5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2013, 01:25 AM
  4. Using MIN on range with upper and lower bounds
    By MWMike in forum Excel General
    Replies: 3
    Last Post: 12-13-2011, 03:13 PM
  5. [SOLVED] How to fix lower and upper bounds for data
    By charter_SKR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2006, 12:35 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