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
Bookmarks