+ Reply to Thread
Results 1 to 5 of 5

compare stacked column bars in a chart

  1. #1
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    compare stacked column bars in a chart

    Dear All,

    I have 2 table with the same headers but different value. I want to draw a chart with 2 stacked bars together in a chart.

    I am not familiar with making the chart, especially with adding the secondary bar chart.

    Please see my attached

    Regards,
    Sarin
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: compare stacked column bars in a chart

    look at the chart1 tab
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: compare stacked column bars in a chart

    Dear rcm,

    Thank you very much for your chart.

    Is there a way to put the X-Axis in the center of the two bars, to look better. And How to identify, for example Group A, Group B (I mean 1st bar belongs to group A, and second bar belongs to Group B), so how can I put Group A, Group B under each bar?

    Kind Regards,
    Sarin

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

    Re: compare stacked column bars in a chart

    Combine your data table and use multi level category labels,
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Contributor
    Join Date
    01-25-2012
    Location
    Cambodia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: compare stacked column bars in a chart

    Thanks Andy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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