+ Reply to Thread
Results 1 to 2 of 2

time comparison bar chart, want two data labels

  1. #1
    Registered User
    Join Date
    06-01-2021
    Location
    San Diego
    MS-Off Ver
    2016
    Posts
    2

    time comparison bar chart, want two data labels

    Hi. Basically built a Gantt Chart, horizontal bar chart that has a start/end date, and a duration field.

    Chart is set up to show only the duration, based on the two dates.

    I have set up labels to show start date outside end for the beginning of each bar.

    Cannot figure out how to set up end date label on same bars.chart.jpg

  2. #2
    Registered User
    Join Date
    06-01-2021
    Location
    San Diego
    MS-Off Ver
    2016
    Posts
    2

    Re: time comparison bar chart, want two data labels

    Ok, figured it out. If this helps anyone, please use, even though it might be rudimentary, it worked.

    To get 2nd label at end of chart bar
    -Left click chart bar
    -Right click "add data labels", then again "add data labels"
    - Shows Duration
    -Right click, select "format data labels"
    -Select box "value from cells"
    -Select column of data for 2nd label
    -De-select "value" and de-select "show leader lines"
    -Can now move 2nd label wherever desired and format it

    Attachment 734907

+ 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. 2 data sets 1 chart (best, column bar) with legend for comparison
    By llyod276 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-12-2018, 06:50 AM
  2. How to have three years data in chart for comparison ?
    By jayeshk in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2016, 06:03 AM
  3. Need help making comparison chart with non-numerical data
    By dgsell in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-15-2013, 02:58 PM
  4. [SOLVED] Help to Chart Comparison Data of 2 sets of data with 5 variables each needed please
    By bluejasmine in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-13-2012, 12:45 PM
  5. ow to create comparison chart using text as value data?
    By deejohn525 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-27-2006, 07:55 AM
  6. [SOLVED] How do I create a comparison chart from a data list?
    By comic guy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-19-2005, 10:05 AM
  7. [SOLVED] Time/Data Comparison
    By SharonP in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-03-2005, 02: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