project status chart (PDR, CDR..) planned vs actual.

**gefmos** · 11-22-2017, 07:25 AM

Hello,

I would like to draw a chart which present the project status.
each project phase (Kick-off, PDR, CDR...) will be the vertical axis
Horisontal Axis is calander dates (Jan, Feb...) and 2 line graph
1 - planned date of completion for each project phase
2 - actual date of completion for each project phase

You can see below some data
dont mind which phase comes first

Will appreciate your help
Moshe

Phase # Date Planed Time Actual time
-----------------------------------------------------------
POC 1 01/01/2018 1/1/18 15/1/18
Rapid proto 2 01/12/2017 1/12/17 1/1/18
First Integration 3 01/11/2017 1/11/17 15/12/17
Mechanic CDR 4 01/10/2017 1/10/17 25/11/17
SW CDR Phase 5 01/09/2017 1/9/17 28/10/17
HW CDR Phase 6 01/08/2017 1/8/17 28/8/17
PDR Phase 7 01/07/2017 1/7/17 15/7/17
Requirements definition 8 01/06/2017 1/6/17 1/6/17
Kick-off meeting 9 01/05/2017 1/5/17 1/5/17

**tuph** · 11-23-2017, 08:44 PM

Hi Moshe. Welcome to the forum. It's much easier to work on solutions if you attach a sample of your workbook. Please be sure to replace any sensitive info like peoples names before uploading the file.

**Kaper** · 11-24-2017, 08:50 AM

I added dummy series to be used for labels (to replace vertical axis labels).
See atteched. Note changed starting value for horizontal series. Top graph has all 3 series visible. Bottom one has dummy series with no line and no markers