+ Reply to Thread
Results 1 to 4 of 4

Stacked bar issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,139

    Stacked bar issue

    hi all

    having an issue with stacked bar. i am trying to have 4 data points on a single axis , split by two individual bars.

    i have attached the file. trying to make a stacked graph to showcase 4 metrics on the x-axis and then on the y-axis have two individual stacked graphs for 2 data points.

    can someone pls help? file attached.
    thxs so much!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,899

    Re: Stacked bar issue

    Maybe try it like this - splitting the data over two columns. See attached
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

  3. #3
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Prefer Excel 2003 but 2007 is great!
    Posts
    1,139

    Re: Stacked bar issue

    hi there

    this works, however, can the legend be ONLY the name in column B? i do not need the legend to go by column C.

    thxs u so much

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,899

    Re: Stacked bar issue

    It can but because its a merged cell and you're showing only two labels for 4 series of data you'll only get two colours in your legend.

    see attached
    Attached Files Attached Files

+ 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. Stacked Bar Chart Issue
    By mansnic in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-14-2017, 11:30 AM
  2. Stacked Bar chart date issue
    By petermikula in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-21-2017, 04:50 PM
  3. [SOLVED] Stacked Bar Values Display Issue
    By nawas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2016, 06:21 AM
  4. Stacked graph overlapping issue
    By rexer231 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-23-2014, 06:16 AM
  5. Diverging Stacked Bar Chart issue
    By Lis7 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-23-2013, 07:00 PM
  6. Stacked columns issue
    By Eemmai in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-02-2013, 10:20 AM
  7. [SOLVED] 100% stacked bar issue on data label
    By sarinky in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2013, 07:08 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