+ Reply to Thread
Results 1 to 4 of 4

Charting with dates!

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Norwich, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Charting with dates!

    Hi all,

    First post to this forum...

    I'm trying to show 2 timelines side by side. I'm not too fussy how we go about it but I'm falling a bit short in my charting knowledge to acheive what I want. I have two columns of data, both contain dates.

    The frst column contains a list of dates which are 6 April on consecutive years (ie. UK tax years).
    The second column is a series of less consistent dates which overlap the more consistent tax years in the first column. These are to be amended by the user as needed.

    See attached for an example.

    I don't mind if the tax years form the x axis of the chart, and the "PIP dates" column is plotted against that. Alternatively, to have "tax year" and "pip dates" plotted as two separate bar charts would be fine too. I just want to show the overlapping dates graphically, like a timeline. Excel isn't great at dealing with dates and I'm coming up short! Any help gratefully received.

    Thanks
    StevePIP data 2.xlsx

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

    Re: Charting with dates!

    Something like this?
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-24-2014
    Location
    Norwich, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Charting with dates!

    Thanks Andy, that's brilliant. Definitely sufficient for what I need. I can tweak that to make it work for us.

    Would it be too complicated to explain how you did it?

    Thanks again
    Steve

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

    Re: Charting with dates!

    using the new data layout in E3:G27 create a line chart with markers.

    Format vertical axis Min=0, Max=2, Major Unit=1.
    Format Tax year series. No line, marker circle sized 16. Marker fill White.
    Format PIP periods series. No Line, marker circle size 10.

+ 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. Charting Dates I dont want
    By tactical in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-20-2011, 10:31 AM
  2. [SOLVED] Charting dates and times
    By jrholden in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-17-2011, 07:23 AM
  3. Charting reverse dates
    By The Muffin Man in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2007, 05:46 PM
  4. Charting with dates
    By changetires in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2006, 05:00 PM
  5. [SOLVED] Charting data against dates where dates are not at fixed intervals
    By PK in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-16-2005, 01:05 AM

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