+ Reply to Thread
Results 1 to 2 of 2

Need help plotting timeline in excel

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    Hobart, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Need help plotting timeline in excel

    sample timeline.xlsx

    Hello,

    Can anyone help me plot a timeline in excel 2007?

    I want to show date plotted against status of harvest season at numerous locations (A, B, C...)

    I have attached some sample data, and a sample chart showing how I want the data to look (note - the chart doesnt match the sample data. I just threw the chart together manually in powerpoint to show what I'm trying to achieve regarding format).

    Also, if possible, I'd like the timeline to show custom dates. i.e. I specify which dates appear on the x-axis, excel spaces them appropriately.

    Any help greatly appreciated!

    Thanks,

    Laura

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Need help plotting timeline in excel

    The easiest way to do this is via code.

    You need to create a set of values to plot and then based on your text table colour the data points.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1