+ Reply to Thread
Results 1 to 6 of 6

making stacks with percentage

  1. #1
    Registered User
    Join Date
    01-16-2009
    Location
    oslo, norway
    MS-Off Ver
    Excel 2007
    Posts
    2

    making stacks with percentage

    Like I have drawn in a drawing program on the side of the columns I want to split into percentage

    view attachment
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    10-11-2007
    Location
    Sweden
    MS-Off Ver
    365
    Posts
    251
    Maybe you can find something useful here Charting in Microsoft Excel

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436
    If you drop the use of 3d effects you can create the chart using a combination stacked column and xy-scatter.

    The lines are created using custom error bars, which are calculated in some helper cells. The data labels are linked to the next set of helper columns.

    Attached is both a xl2003 and 2007 versions
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-16-2009
    Location
    oslo, norway
    MS-Off Ver
    Excel 2007
    Posts
    2
    Excellent!!

  5. #5
    Registered User
    Join Date
    12-12-2006
    Posts
    6

    Re: making stacks with percentage

    Hi,

    I was trying to use your graph and add 5 more variables. But I cant get the custom y error bars in the graph.
    Any tips ?

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

    Re: making stacks with percentage

    Hi wviveen,

    start a new thread including a link to this one.

    In the new thread post what you have already tried.

+ 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