+ Reply to Thread
Results 1 to 3 of 3

Bar chart along with stacked bar chart

  1. #1
    Registered User
    Join Date
    10-21-2010
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    34

    Bar chart along with stacked bar chart

    Hi

    I need a chart with both normal bar chart and stacked bar chart. the data is attached below. . The scenario is follows. I buy 10 apples a week and i maintain a breakup the consumption for the week. I need the apples avialable (10) as a single bar and adjucent bar to be stacked information about who consumed how many and how many wastage.

    Can any one help
    Attached Files Attached Files

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Bar chart along with stacked bar chart

    not real clear why you want both but see another JP's blog http://peltiertech.com/WordPress/clu...mn-bar-charts/
    and also Mr. Pope's example here http://www.andypope.info/charts/stackside.htm
    Last edited by JosephP; 05-21-2013 at 05:09 AM.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    shelton, wa
    MS-Off Ver
    Office 365
    Posts
    24

    Re: Bar chart along with stacked bar chart

    I believe I re-attached your sheet correctly showing a bar with a stacked bar next to it without having two charts impossed over each other. It's more of a tricking excel by putting in some blank lines and staggering your data. I hope this is what you were looking for. I also removed the out side ticks from the lower axis, the staggering of lines makes the labels not very friendly to the eye.
    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)

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