+ Reply to Thread
Results 1 to 3 of 3

Having Overlapping Time line in Stack Bar Chart.

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    427

    Having Overlapping Time line in Stack Bar Chart.

    Hi, i have two data set, one is Estimate Start and End Date, one is Actual Start and End Date.
    I wanted to make Both appear in one Bar Chart, with 50% transparent so that user can have a better visual understanding.
    So far, i have only manage to do the Estimate Start and End Date, i tried to put in the Actual Start and End date, but somehow, cant.

    Would appreciate if anyone can help.

    See my attachment for example.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    13

    Re: Having Overlapping Time line in Stack Bar Chart.

    You start the right way, but the hard part is following.
    Let calculate the Actual data the same way as Estimation.
    Add Actual data into the chart, then change them to Secondary.
    Delete Secondary Horizontal Axis.
    Add Secondary Vertical Axis, set Reverse Order, then set Label Position to None.
    Finally set format as you want.


    See result in the attachment.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    427

    Re: Having Overlapping Time line in Stack Bar Chart.

    Hi, thanks very much.

    But how do we Add Secondary Vertical Axis?

+ 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. [SOLVED] Fix data labels overlapping in line chart
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2020, 09:27 AM
  2. Trending line Overlapping regression line
    By maxypro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2019, 04:29 PM
  3. 3 date line's one time chart line?
    By Frigide in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-06-2019, 01:41 PM
  4. Replies: 0
    Last Post: 01-07-2015, 01:22 PM
  5. How to create a vertical reference line on a time series line chart
    By Bladebgii in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-23-2012, 10:17 AM
  6. Counting Overlapping Time & Non-Overlapping Time
    By I_need_help1 in forum Excel General
    Replies: 4
    Last Post: 02-08-2011, 02:36 PM
  7. Stack-Line Chart
    By Reyan123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2010, 01:43 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