+ Reply to Thread
Results 1 to 2 of 2

Stacked Column Charts

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    Stacked Column Charts

    Hi,

    Looking for a bit of help with stacked column charts for a presentation.

    Attached is some sample data as an example to explain what I am hoping to achieve.

    For each sport in my table, I have a 'scope' (maximum available, i.e. 100%) and 'capability' (the amount I can cover with current resources, i.e. a percentage of the Scope).

    For example; The sport of Football has a Scope of 60,000 matches and I have the capability to cover 54,000 matches. So, I want my Football to be 90% covered.

    Please let me know if this doesn't make sense and I will try to explain again.

    Thanks,
    Adam.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,311

    Re: Stacked Column Charts

    Make a chart with the values of (football) 54,000 and 6,000 (=60,000-54,000)
    Then you see that 54,000 is 90% covered
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. column charts: stacked / non stacked hybrid ??
    By littlejimmy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-24-2012, 11:36 AM
  2. [SOLVED] How to create these two stacked column charts?
    By rcurious in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-19-2012, 04:33 PM
  3. True x,y,z stacked column charts
    By geodude in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2011, 10:34 AM
  4. Percentage Values Stacked Column Charts
    By starbwoy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-31-2009, 12:25 AM
  5. Combining Stacked and Clustered Column Charts
    By ChemistB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-02-2008, 09:59 AM
  6. Stacked column charts
    By simcol in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2006, 11:50 PM
  7. Double 100% Stacked column charts
    By buggy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-11-2005, 03:36 PM
  8. Column Charts - stacked and grouped
    By jtd1 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-15-2005, 10:59 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