Results 1 to 4 of 4

Creating a Scatter or Line Graph Using a Wide Range of Dates

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    Boise, Idaho
    MS-Off Ver
    2010
    Posts
    5

    Creating a Scatter or Line Graph Using a Wide Range of Dates

    Hello,

    So I have two sets of data. The first are hire dates and the other is separation dates. These obviously span of a significant period of time. I would like to create either a scatter or line graph in the hope of viewing trends. I would like to create a couple different graphs so I'd like to be able to chose what the graph displays at will. For example, I might want to see trends year to year, however at other times I might want to see trends month to month covering a single year. Does any one know how to do this? I won't ever need it down to the day, just by month and/or year. I have attached the spreadsheet I am using. There are four columns with information in them but I'm looking to graph the last two. Thanks in advance for any help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [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
  2. [SOLVED] Change all line thicknesses in scatter graph
    By strokebow in forum Excel General
    Replies: 1
    Last Post: 01-02-2013, 12:58 PM
  3. Replies: 1
    Last Post: 03-23-2012, 10:17 PM
  4. Creating scatter graph
    By Layo909 in forum Excel General
    Replies: 1
    Last Post: 07-12-2011, 07:38 AM
  5. Extra line on scatter graph that should not be there.
    By urbanvibration in forum Excel General
    Replies: 1
    Last Post: 05-25-2010, 02:25 PM
  6. Plotting a line over a scatter graph
    By rupakbanerjee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-30-2009, 12:03 PM
  7. Scatter plot and line graph combination
    By Tim Gilderseeve in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2005, 03:05 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