+ Reply to Thread
Results 1 to 5 of 5

Mixed Chart - Stacked Bars X-Y

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    New Hampshire
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Mixed Chart - Stacked Bars X-Y

    Help! I've spent (more than) a few hours playing with Inserting a Chart needed badly...

    Data is several series with a High and Low value on an X-axis (not sequential).

    I'd like to create a bar chart with one series bar starting at the 'low-Y' and with top at the 'high'-Y. I can do this by clustering the two data points with 100% overlap, the 'low-Y' being no fill/ no outline in front of the 'high-Y'.

    What I can't figure out is how to have several series of these "overlapped low/high" bars clustered at a given X-value.

    ! I hope this is somewhat clear ! I pray there's someone out there that can help !

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

    Re: Mixed Chart - Stacked Bars X-Y

    I personally don't understand what you are trying to do. Since no one else has responded, I am guessing you need to put a little more thought into describing what you want to do.

    In some ways, what you describe sounds like a bubble chart: https://support.office.com/en-us/art...rs=en-US&ad=US

    In other ways, I think of a regular XY scatter chart with error bars: https://support.office.com/en-us/art...rs=en-US&ad=US

    In other ways, I think of a "box and whisker" chart: http://peltiertech.com/excel-box-and...ams-box-plots/

    Or maybe a floating column chart of some kind: http://peltiertech.com/Excel/Charts/...ngColumns.html

    If nothing else, see if those suggestions give you a context to describe what you want.
    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
    12-17-2014
    Location
    New Hampshire
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Re: Mixed Chart - Stacked Bars X-Y

    Ah ha! The floating bar chart was what I was trying to describe.

    Now to figure out how I can do this with multiple series, so using the example, there would be more than one "low-range-high" for each month (of course with the data I need to plot this makes physical sense).

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

    Re: Mixed Chart - Stacked Bars X-Y

    If I am understanding and anticipating what you are doing correctly, I think you will want to review this on what Jon calls a "clustered + stacked" column chart: http://peltiertech.com/clustered-sta...mn-bar-charts/ I expect that you should be able to get the effect you want by combining the floating column with the clustered+stacked chart ideas.

  5. #5
    Registered User
    Join Date
    12-17-2014
    Location
    New Hampshire
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    Re: Mixed Chart - Stacked Bars X-Y

    Yes, perfect MrShorty! This is exactly what I was looking for. And I'm glad it's not so obvious that I should have figured it out myself.

+ 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. coloring bars in a stacked bar chart (Yamazumi chart) on basis of text
    By Rob201 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2014, 04:56 AM
  2. How to chart 2 stacked bars per day?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-24-2009, 11:59 AM
  3. [SOLVED] Stacked bars in a gnatt chart
    By Gnatt in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 03:35 PM
  4. [SOLVED] Can I setup mixed bar chart where last column is stacked?
    By Wobbly Steve in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2005, 12:05 PM
  5. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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