+ Reply to Thread
Results 1 to 6 of 6

unequal intervals for stacked bar chart

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    iowa
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    63

    unequal intervals for stacked bar chart

    I have a cumulative histogram with unequal intervals.

    I couldn't get a line-chart to show this, it assumed that the data were equi-spaced (yes?)

    So I used a scatter graph, and lines connecting points - great!

    But now I want to add a stacked-bar chart to show the composition of each value on the chart below the plotted points. Again I found that bar charts assume equi-spacing. Some proposals I see are to add a set of intermediate equi-spaced values, and use a step-graph to merge them. That is not what I want, I want to just add the stacked bars below each data point - suggestions?

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: unequal intervals for stacked bar chart

    Vertical Error Bars with their "Error Amount" set to "Custom" fed by a helper column... or something like that.

    Post a sample workbook and I'll turn it around with a demo.

  3. #3
    Registered User
    Join Date
    10-16-2008
    Location
    iowa
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    63

    Re: unequal intervals for stacked bar chart

    Thanks for the offer - I didn't understand all of it, but here is the sample!
    Attached Files Attached Files

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: unequal intervals for stacked bar chart

    See attached.

    I had to work around your external data links for some named ranges, so that might cause trouble. If the table is full of #VALUE! errrors that's why, although hopefully I didn't break that.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-16-2008
    Location
    iowa
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    63

    Re: unequal intervals for stacked bar chart

    Thanks - very nice!

    I want to switch the stacking of the Regular & special, but since I didn't understand how you did it all, couldn't convince Excel to do it.

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

    Re: unequal intervals for stacked bar chart

    You can create vary width stacked columns if you want.
    http://www.andypope.info/charts/colwidth2.htm
    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. Unequal intervals in x-axis values
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-01-2013, 06:50 AM
  2. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  3. [SOLVED] How can I combine a stacked bar chart with stacked colum chart?
    By Sin in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-19-2005, 11:55 PM
  4. [SOLVED] ?make a combo chart with 1 stacked bar and 1 not stacked, + show t
    By y in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  5. [SOLVED] 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

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