+ Reply to Thread
Results 1 to 6 of 6

Graph with 3 different time periods?

Hybrid View

adiski Graph with 3 different time... 03-29-2015, 07:09 AM
Andy Pope Re: Graph with 3 different... 03-29-2015, 07:42 AM
adiski Re: Graph with 3 different... 03-29-2015, 07:55 AM
adiski Re: Graph with 3 different... 03-29-2015, 08:50 AM
Andy Pope Re: Graph with 3 different... 03-29-2015, 10:02 AM
adiski Re: Graph with 3 different... 03-30-2015, 02:56 AM
  1. 03-29-2015, 07:42 AM #1
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Graph with 3 different time periods?

    You need to change the layout of your data. See attached
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  2. 03-29-2015, 07:55 AM #2
    adiski is offline
    Registered User
    Join Date
    03-28-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Graph with 3 different time periods?

    Wow that's great thank you so much!
    Reply With QuoteRegister To Reply
  3. 03-29-2015, 08:50 AM #3
    adiski is offline
    Registered User
    Join Date
    03-28-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Graph with 3 different time periods?

    Do you know how to add a trendline so that it only displays the trendline over that period?
    I wanted to add 3 trendlines but not have them overlap...
    Reply With QuoteRegister To Reply
  4. 03-29-2015, 10:02 AM #4
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Graph with 3 different time periods?

    you would need yo use xy-scatter chart. And adjust the ranges used as the data source for each series
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-30-2015, 02:56 AM #5
    adiski is offline
    Registered User
    Join Date
    03-28-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Graph with 3 different time periods?

    Brilliant, thanks again! What a good forum.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate time by time periods splitting productivity
    By cgfourman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2014, 03:04 PM
  2. How to automatically draw a graph with wanted time periods?
    By Jaakkolo in forum Excel General
    Replies: 2
    Last Post: 08-06-2012, 07:38 AM
  3. time durations within time periods (greater than/less than?)
    By rosieb13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2007, 10:38 AM
  4. periods of time
    By Ben in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-05-2006, 03:47 PM
  5. [SOLVED] how do I create a line graph for part of the periods?
    By Harold Rostoker in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-05-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1