+ Reply to Thread
Results 1 to 3 of 3

% Percent % Bar Status?

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    Posts
    922

    Thumbs up % Percent % Bar Status?

    Hi,

    I created a horizontal bar chart that shows an estimated duration of given tasks. I would like a % bar status (based on column U of my attached example) on top of it & if possible, thinner than the planned tasks bars.

    I attached an example for reference or assistance.

    Thanks again....
    Attached Files Attached Files
    Last edited by mycon73; 01-11-2014 at 06:14 PM.
    MyCon
    -- Using Latest Version of Excel

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

    Re: % Percent % Bar Status?

    First you need to calculate the actual duration.
    The you need 2 series on both primary and secondary axis.

    So add the Start Date again as a series and use newly calculated duration for the 4th series.
    Add secondary Vertical axis so you can reverse the scale.
    Format secondary horizontal axis scales to match primary.

    increase gap width of bars.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    Posts
    922

    Re: % Percent % Bar Status?

    Hi Andy Pope,

    Great solution for originally asked question!!! Thanks for the feedback.

+ 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. Formula or function to find percent of a percent in a population
    By maldron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 08:26 PM
  2. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  3. Graph Actual Percent with Suggested Percent
    By jaytaylor in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-05-2010, 07:09 AM
  4. Replies: 1
    Last Post: 06-01-2006, 01:15 PM
  5. [SOLVED] Formatting a number to look like a Percent without a percent sign
    By David Iacoponi in forum Excel General
    Replies: 2
    Last Post: 09-15-2005, 02:05 PM

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