Creating line graph of dates for four years

**wagstaffjh** · 10-03-2014, 02:30 PM

I've been out of practice making graphs in excel and need a line graph of data in the attached workbook where the X axis is over time (month-to-month over the time period of the dates) and the y axis is the displays the percentage of total projects completed (all dates are project complete dates) for their respective year. The four lines over time being years 2014, 2013, 2012, and 2011. I have already normalized the year dates for years 2013, 2012, and 2011 appropriately to the 2014 dates. Thank you for your help.

LineGraph.xlsx

**melknothink** · 10-03-2014, 06:23 PM

Hey,

So attached is what I think you are looking for. Just a note, there are more dates for 2013-2011 and the ending ones look like the year is incorrect (e.g. 1901 and 1902)

- Melk

Creating line graph of dates for four years

LinkBack

Thread Tools

Rate This Thread

Display

Creating line graph of dates for four years

Re: Creating line graph of dates for four years

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating a line graph over a bar graph to show actual v.s. goal?

How to dynamic chart a rolling three years (each year as separate line onf graph)

[SOLVED] How to incorp missing years into a timeline line graph Xaxis without the values taken as 0

creating a line graph

[SOLVED] Creating a line and bar graph?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions