+ Reply to Thread
Results 1 to 5 of 5

Bubble chart with two threshold horizontal lines

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    10

    Bubble chart with two threshold horizontal lines

    Hello,

    I just want to know if it is possible create a Bubble chart with two threshold horizontal lines in excel 2007.
    I have to insert on the bubble chart two lines (10% and 16%).
    Thanks in advance

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

    Re: Bubble chart with two threshold horizontal lines

    I would try adding another data series consisting of:

    X value -- max x
    Y value -- 0.1 and 0.16
    size -- any reasonably value

    Then select this series and add error bars to that series. Delete the vertical error bars, then format the horizontal error bars so that only the negative error bar shows and set it to 100%. Then set the size value to 0 to hide this second series, leaving only the negative horizontal error bar visible.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-15-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    10

    Re: Bubble chart with two threshold horizontal lines

    Hello MrShorty,

    Thank you for help. Really appreciated !!
    I will try your sugestion. But, I have one doubt, on the bubble chart i use 3 series:

    Series 1 - Product name
    Series 2 - Damage (in %)
    Series 3 - Bubble Size (Total of product)

    How i add the series 4 to the bubble chart?
    Or, I just have to work only with the Error Bars??
    Thank you!

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,904

    Re: Bubble chart with two threshold horizontal lines

    But, I have one doubt, on the bubble chart i use 3 series:

    Series 1 - Product name
    Series 2 - Damage (in %)
    Series 3 - Bubble Size (Total of product)
    I think you are misunderstanding. Those three sets of values together constitute a single data series.

    How i add the series 4 to the bubble chart?
    I frequently use the "Select Data" dialog to add data series. Select the chart -> Design -> Select Data -> Add -> Select the desired ranges/values for X values, Y values, size values, and name for the new series. Exit the diaglogs, then continue adding error bars to this new series.

  5. #5
    Registered User
    Join Date
    01-15-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    10

    Re: Bubble chart with two threshold horizontal lines

    Understood.
    Thanks a lot!

+ 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. Leader / Leading Lines in Bubble Chart
    By ajm036 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-05-2015, 07:26 AM
  2. Horizontal bar chart with target lines
    By golfoscar in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-08-2014, 03:57 AM
  3. Replies: 1
    Last Post: 06-18-2014, 04:32 PM
  4. Horizontal Lines on Waterfall Chart
    By BoomerSooner2014 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-21-2014, 01:30 PM
  5. Edit bubble behind another bubble in bubble chart (2007)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-14-2009, 03:10 PM
  6. Creating X & Y Mean Lines on Bubble Chart
    By Chris Turnbull in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2006, 04:10 PM
  7. Horizontal lines in waterfall chart
    By Tim in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2005, 07: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