+ Reply to Thread
Results 1 to 3 of 3

Creating a graph with only positive numbers from 2 dates

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    California
    MS-Off Ver
    2016
    Posts
    13

    Creating a graph with only positive numbers from 2 dates

    Hey there,

    I currently have a table with columns for "Orientation Date" and "Retired Date." I entered a formula to give me the amount of networkdays between the 2 dates, however the outcome is negative if there isn't a retired date entered. My end goal is to have a chart of the average amount of days (obviously only the positive numbers) these employees were employed and ignore those who are still employed (the negative numbers).

    Thank you in advance!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Creating a graph with only positive numbers from 2 dates

    Have you looked into building a pivot chart and then pivot out the values less than zero.

    If this does not work for you, how about a sample workbook.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-19-2019
    Location
    London
    MS-Off Ver
    2003-2016/2016 Mac
    Posts
    57

    Re: Creating a graph with only positive numbers from 2 dates

    Use the formula

    Please Login or Register  to view this content.

+ 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. Creating a Line Graph with vastly different range of numbers
    By KingCorg in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-02-2017, 10:12 AM
  2. Creating a Scatter or Line Graph Using a Wide Range of Dates
    By awebster in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-23-2016, 12:10 PM
  3. [SOLVED] Creating line graph of dates for four years
    By wagstaffjh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-03-2014, 06:23 PM
  4. Creating a scatter graph with letters rather than numbers
    By STEVE1234567 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2013, 06:26 PM
  5. Replies: 0
    Last Post: 05-10-2012, 06:56 PM
  6. Creating a graph from positive figures
    By se7encm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2010, 04:12 PM
  7. How do I convert dates into numbers for the use of a graph
    By zoolander10 in forum Excel General
    Replies: 2
    Last Post: 07-07-2008, 03:41 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