+ Reply to Thread
Results 1 to 2 of 2

Plot stacked absolute numbers and stacked percentage (100 %) in one graph

  1. #1
    Registered User
    Join Date
    08-23-2016
    Location
    Zurich, Switzerland
    MS-Off Ver
    2010
    Posts
    1

    Plot stacked absolute numbers and stacked percentage (100 %) in one graph

    Dear all,

    I have worked with excel for many years, but I have rarely done graphs that go further than the standard functionality. Hence I have little experience and wanted to take this opportunity to seek help from this community. I work in finance in Zurich.

    What I aim to do is the following:

    - we have three business streams: LSC, SME and CTF
    - in each stream, there are a number of documents that need to be sent out to clients
    - each document represents a contract (e.g. a trade finance guarantee or a loan) with a certain value

    So for the streams on the x-axis, I would like to plot:

    - on the left y-axis a stacked column of the value of the sent and then above the not sent contracts (in absolute terms) - so mgmt can see the impact of each stream in absolute terms
    - on the right x-axis a stacked column (in percentage, so for all the streams the columns should have the same height) with the distribution of sent and not sent

    This chart would give valuable insights: firstly, mgmt can see the status of sending the documents (in percentage), but also the absolute impact of each stream.

    I would be very happy if somebody found time to assist me on this.


    ---

    EDIT: Problem solved - quicker than I thought. Just click on "Change Series Chart Type". New question now: how can I have the columns next to each other instead of overlapping? If I separate them, one stack stays central, but the other one is torn apart - the lower one to the left and the upper one to the right of the then center column

    Many thanks in advance
    Fab
    Attached Files Attached Files
    Last edited by kufa85; 08-23-2016 at 05:11 AM.

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Plot stacked absolute numbers and stacked percentage (100 %) in one graph

    Hi

    If you click on each column then right click to select "Format Data Series" by changing the % for either "Series Overlap" or "Gap Width" you may achieve what you want.

    Does this help

    Cheers

+ 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 graph with numbers and linked text name to cell VBA
    By mucbeanz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2016, 03:21 AM
  2. [SOLVED] 100% Stacked Bar Graph with Label in the center of the Plot Area
    By codeslizer in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-15-2013, 05:05 AM
  3. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  4. [SOLVED] Creating a stacked column chart with percentage in the graph
    By MQ in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-10-2011, 02:53 PM
  5. Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  6. How do I show negative numbers on a stacked graph
    By JMZ in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-26-2005, 12:06 PM
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 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