+ Reply to Thread
Results 1 to 2 of 2

To have cluster and stacked bar in one chart and Qns2 to include % beside data label

  1. #1
    Registered User
    Join Date
    11-03-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    29

    To have cluster and stacked bar in one chart and Qns2 to include % beside data label

    Hi, I would like to 1) include a cluster bar beside a stacked bar chart (not sure if it can be done) and 2) include the % beside the data label value in the bar chart. Please see the enclosed working file. Thanks.
    Attached Files Attached Files

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

    Re: To have cluster and stacked bar in one chart and Qns2 to include % beside data label

    clustered and stacked column/bar charts are quite possible in Excel: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that most of the work is arranging the data in the spreadsheet, and then creating a standard clustered bar/column chart from that copy of the data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Stacked cluster chart
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-09-2018, 06:10 PM
  2. Replies: 2
    Last Post: 10-25-2013, 10:22 AM
  3. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  4. Excel 2007 : Cluster-Stacked Column Chart Excel 2007
    By starbecks in forum Excel General
    Replies: 4
    Last Post: 06-13-2012, 02:57 PM
  5. [SOLVED] cluster & stacked & line in one chart
    By Scott in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2006, 12:30 PM
  6. [SOLVED] How can I create a combination stacked & cluster column chart?
    By fullerdb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-03-2006, 01:30 PM
  7. Percent Data Label on 100% Stacked Column Chart
    By PNichols in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2005, 09:05 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